equivalent of a sql query in posgresql - Drizzle Team

Drizzle Team•2y ago•

1 reply

equivalent of a sql query in posgresql

help me i dont understand how to make subquery in posgresql

SELECT products.product_name, products.units_in_stock
FROM products
WHERE products.units_in_stock = (
    SELECT max(products.units_in_stock)
    FROM products
    WHERE products.units_in_stock > 30
);

SELECT products.product_name, products.units_in_stock
FROM products
WHERE products.units_in_stock = (
    SELECT max(products.units_in_stock)
    FROM products
    WHERE products.units_in_stock > 30
);