CODEWITHSUNDEEP
sqloracle-databasedatabase-migration
user234568
user234568

Reputation: 815

How do I translate SQL SERVER Query into Oracle SQL?

I'm trying to translate the query below from SQL Server to Oracle SQL. I'm unsure about the IFF condition for the oracle.

SELECT IIF(Grade<8, NULL,Name) As Name ,Grade,Marks 
FROM Grade,Students 
WHERE Marks>=Min_Mark and Marks<=Max_Mark 
ORDER BY Grade DESC, Name ASC;

Upvotes: 0

Views: 72

Answers (1)

Zaynul Abadin Tuhin
Zaynul Abadin Tuhin

Reputation: 32003

You can try like below

SELECT case when Grade<8 then  NULL else Name end As Name ,Grade,Marks 
FROM Grade,Students 
WHERE Marks>=Min_Mark and Marks<=Max_Mark 
ORDER BY Grade DESC, Name ASC;

but i prefer explicit join like below

SELECT case when Grade<8 then  NULL else Name end As Name ,Grade,Marks 
    FROM Grade join Students 
    on  Grade.Marks>=Students.Min_Mark and
       Grade.Marks<=Students.Max_Mark 
    ORDER BY Grade DESC, Name ASC;

Upvotes: 2

Related Questions