Oracle'dan PostgreSQL'e geçiş – SQL dönüşümleri (Brian)

• Oracle: SELECT * FROM (SELECT customer_id FROM payments ORDER BY amount DESC) WHERE rownum > 20 AND rownum <= 30;

• PostgreSQL: SELECT customer_id FROM payments ORDER BY amount DESC LIMIT 20 OFFSET 10;