[PostgreSQL] GREATER & LEAST

less than 1 minute read

GREATER & LEAST

  • GREATER: returns the greatest value from the list
  • LEAST: returns the least(smallest) value from the list
-- returns 300
SELECT GREATEST(300, 100, 50, 200)

-- returns 50
SELECT LEAST(300, 100, 50, 200)