postgres select max value
snippet in sql

postgres select max value

user927

SELECT * FROM payment
WHERE amount = (
 	SELECT
  	   MAX(amount)
	FROM
	   payment
);