Skip to content
Advertisement

Understand and convert query to Oracle SQL

I am a little bit confusing and I am totally nOoB in PHP and I stuck in one query which made me problem.

JavaScript

If I would like transform this to Oracle SQL Is is something like this

JavaScript

Advertisement

Answer

Check the following:

JavaScript

It should produce an SQL query as follow, which will put the mark 2 if the student status equals success-student.

JavaScript
User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement