1. Home
  2. Docs
  3. Oracle to PostgreSQL Migration
  4. SQL – Oracle vs PG
  5. Migrate Subqueries

Migrate Subqueries

A subquery or inner query is a SELECT query nested inside another SQL query called as outer query. The outer query can be a SELECT, INSERT, UPDATE, DELETE, SET statements or inside another subquery.

In PostgreSQL, inline view subqueries must have an alias. If alias is not present PG, throws error.

Was this article helpful to you? Yes No

How can we help?