خرید بک لینک

Vote count: 0

Here is a simple question, when I have (A,B) as a result of my query, I would like to have only (A,B), not (B,A).

For exemple my query retus :

161, 52 
161, 53
53, 161
53, 161

Here is my query :

SELECT S1.SURVEY_ID, S2.SURVEY_ID

  FROM SURVEYS S1, SURVEYS S2

  WHERE (S2.START_DATE BETWEEN S1.START_DATE and S1.END_DATE
  OR S2.END_DATE BETWEEN S1.START_DATE and S1.END_DATE)
  AND S1.SURVEY_ID != S2.SURVEY_ID

ORDER BY S1.SURVEY_ID, S2.SURVEY_ID

asked 18 secs ago

برچسب: نویسنده: استخدام کار تاريخ: سه شنبه 8 تير 1395 ساعت: 18:54

صفحه بندی