You can find a lot of examples in sql dialects differences table.
Enter PostgreSQL Query below:
MySQLFirebirdSQLMS SQLOracle
This is your query after conversion:
If it is incorrect please inform us:
