Just to throw another option, I often like to use
IN
since it makes the query a bit more simplified and often removes the need for additional parenthesis around OR section.
In other words to modify the good answer from Kornfeld Eliyahu Peter you can use something like
SELECT a.STATION_ID,
a.SENSORNAME,
a.TIME_TAG,
a.VALUE
FROM XC_DATA1 a
WHERE (STATION_ID = 'AIN SEBOU' AND SENSORNAME IN ('NIVEAU', 'PLUIE1HR'))
OR (STATION_ID = 'AZZABA' AND SENSORNAME IN ('NIVEAU'))
The latter IN could also be equality but I used IN to keep the comparisons similar.
See
IN (Transact-SQL)[
^]