SQL in Oracle and PostgreSQL, offers a handful of Clauses to use in conjunction with SQL statements.
This chapter describes you the types of SQL clauses available in Oracle and PostgresSQL. The “Supported in Oracle?” column in the table below indicates whether the feature is supported in Oracle. Similarly, “Supported in PostgreSQL?” column indicates whether the feature is supported in PostgreSQL database or not.
| SQL Clause | Supported in Oracle? | Supported in PostgreSQL? |
|---|---|---|
| FROM | Yes | Yes |
| WHERE | Yes | Yes |
| ORDER BY | Yes | Yes |
| GROUP BY | Yes | Yes |
| HAVING | Yes | Yes |
| WITH | Yes | Yes |
| DISTINCT | Yes | Yes |
| INTO | Yes | Yes |
| LIMIT | No | Yes |
| OVER | Yes | Yes |