1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| WITH DATA AS (
SELECT 5 as origine_id, 2 as language_id from dual union
SELECT 5 as origine_id, 1 as language_id from dual union
SELECT 3 as origine_id, 1 as language_id from dual
)
SELECT * FROM DATA
WHERE origine_id=5 AND language_id =2 OR language_id =1;
ORIGINE_ID LANGUAGE_ID
---------------------- ----------------------
3 1
5 1
5 2
WITH DATA AS (
SELECT 5 as origine_id, 2 as language_id from dual union
SELECT 5 as origine_id, 1 as language_id from dual union
SELECT 3 as origine_id, 1 as language_id from dual
)
SELECT * FROM DATA
WHERE origine_id=5 AND (language_id =2 OR language_id =1);
ORIGINE_ID LANGUAGE_ID
---------------------- ----------------------
5 1
5 2 |
Partager