WHERE

Add a WHERE clause after FROM to filter the rows:

SELECT *
FROM ocean_profiles
WHERE latitude  BETWEEN 50 AND 60
  AND longitude BETWEEN -10 AND 10
  AND time >= '2024-01-01'
  AND temperature IS NOT NULL

Comparison operators

=, !=, <, >, <= and >= work on numbers, strings and timestamps:

WHERE quality_flag = 1
WHERE depth <= 200
WHERE time > '2024-01-01'

BETWEEN

BETWEEN includes both limits:

WHERE depth BETWEEN 0 AND 200
WHERE time BETWEEN '2024-01-01' AND '2024-12-31'
WHERE latitude BETWEEN -60 AND 60

IN

IN matches a value against a list:

WHERE platform_code IN ('6900001', '6900002', '6900003')
WHERE quality_flag IN (1, 2)

LIKE

LIKE matches a pattern. % matches any number of characters. _ matches one character:

WHERE cruise_id LIKE '2024%'
WHERE station_id LIKE 'ARGO___'

IS NULL / IS NOT NULL

WHERE temperature IS NOT NULL
WHERE doxy IS NULL

AND / OR / NOT

Combine conditions with the logical operators:

WHERE temperature > 0 AND salinity > 30

WHERE temperature < 0 OR depth > 500

WHERE NOT (quality_flag = 9)

WHERE depth BETWEEN 0 AND 200
  AND (temperature IS NOT NULL OR salinity IS NOT NULL)

Date and time filters

WHERE time >= '2024-01-01'

WHERE time BETWEEN '2024-01-01' AND '2024-12-31'

WHERE DATE_TRUNC('month', time) = '2024-06-01'