postgresql how to return only max code example
Example: postgres select max value
SELECT * FROM payment
WHERE amount = (
SELECT
MAX(amount)
FROM
payment
);
SELECT * FROM payment
WHERE amount = (
SELECT
MAX(amount)
FROM
payment
);