Nzoth
Nzoth
DTDrizzle Team
Created by Nzoth on 5/24/2024 in #help
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
);
2 replies