How make a select with "repeated" condition in SQL?

Question

I have the following select that need to be done:

select top 1 a, b, c, d from Products where
CodDep = 10 or
CodDep = 11 or
CodDep = 12 or CodDep = 13 or
CodDep = 26 or
CodDep = 27 or CodDep = 32 or
CodDep = 34 or
CodDep = 248442 or
CodDep = 259741 order by LastUpdate

Is there an easy way to do this without all this repetition?

score 5 · Accepted Answer · answered Dec 21 '11 at 05:34

5

select top 1 
  a, b, c, d 
from 
  Products 
where
  CodDep IN (10,12,12,13,26,27,32,34,248442,259741)
order by 
  LastUpdate

answered Dec 21 '11 at 05:34

Jake Feasel

16,359
5
50
65

Somnath Muluk · Answer 2 · 2011-12-21T05:44:01.640

0

Try this query:

SELECT TOP 1 a, b, c, d FROM Products WHERE
CodDep IN (10,11,12,13,26,27,32,34,248442,259741) ORDER BY LastUpdate

edited Dec 21 '11 at 05:44

answered Dec 21 '11 at 05:36

Somnath Muluk

51,453
32
215
222

I dont think there is Limit keyword in SQLServer. I am guess sql sever because of Top keyword in original query. – Zohaib Dec 21 '11 at 05:39
OK. I havn't assumed SQL server. I have changed answer. Thanks for suggestion. – Somnath Muluk Dec 21 '11 at 05:43

score 0 · Answer 3 · edited May 23 '17 at 10:34

SQL has but one data structure: the table. Put the values in a table and semi join to that table e.g.

WITH Params
     AS 
     (
      SELECT * 
        FROM (
              VALUES (10), (11), (12), (13),
                     (26), (27), (32), (34), 
                     (248442), (259741)
             ) AS T (CodDep)
     )
SELECT TOP 1 a, b, c, d 
  FROM Products 
 WHERE CodDep IN (SELECT CodDep FROM Params)
 ORDER 
    BY LastUpdate;

How make a select with "repeated" condition in SQL?

3 Answers3