How do I translate SQL SERVER Query into Oracle SQL?

Question

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;

You should stop using those ancient, outdated and fragile implicit joins in the where clause and switch to an explicit JOIN operator — user330315
– user330315, Commented Sep 26, 2018 at 8:49

Zaynul Abadin Tuhin · Accepted Answer · 2018-09-26 08:48:03Z

2

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;

answered Sep 26, 2018 at 8:48

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

George Menoutis Over a year ago

Almost everyone agrees on the second query being best practice

user234568 Over a year ago

Thanks for answering. Very beneficial indeed.

Collectives™ on Stack Overflow

How do I translate SQL SERVER Query into Oracle SQL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related