[Solved] MySQL Query to Oracle SQL [closed]

by


All you need to do is remove the < and > characters:

SELECT r1.rnr, r1.anaam
FROM regisseur r1, regisseur r2
WHERE r2.anaam = 'input last name director'
AND r1.gdatum < r2.gbdatum

Here’s a working demo on SQLFiddle.

Presuming you don’t have a good reason to SELECT from regisseur twice, this can be further condensed down to:

SELECT rnr, anaam
FROM regisseur
WHERE anaam = 'input last name director'
AND gdatum < gbdatum

1

solved MySQL Query to Oracle SQL [closed]