May i use anything else instead of "IN" clause?

• Pravin Patel-491467

  Say Hey Kid

  Points: 674

  More actions

  November 24, 2009 at 1:29 am

  #218033

  SELECT A.Name

  FROM Students

  WHERE

  A.No IN (22,34,12,67)

  Hi Guys,

  In above query i am using "IN" clause to find out Student No. but some time no. of find are very large.

  Is there any other option then "IN". can i use anything else instead of "IN"?

  Thanks in Advance.

  Pravin Patel.

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  November 24, 2009 at 3:06 am

  #1083338

  Pravin Patel-491467 (11/24/2009)

  ---

  SELECT A.Name

  FROM Students

  WHERE

  A.No IN (22,34,12,67)

  Hi Guys,

  In above query i am using "IN" clause to find out Student No. but some time no. of find are very large.

  Thanks in Advance.

  Pravin Patel.

  Your requirement is not clear enough. But if you dont want to hardcode the values in there, u can do something like this,

  SELECT A.Name

  FROM Students

  WHERE

  A.No IN (SELECT ID FROM <TABLE> WHERE <<YOUR CONDITION>>)

  Is there any other option then "IN". can i use anything else instead of "IN"?

  Plenty of options but depends what you want to do!

  ---------------------------------------------------------------------------------

• Slick84

  SSCertifiable

  Points: 5602

  More actions

  November 24, 2009 at 12:32 pm

  #1083625

  Or if those are the student id's that you need, just put more filters in there using the AND keyword.

  So it would be something like..

  WHERE StudentId IN(1,2,3,4)

  AND StudentName LIKE '%Tom%'

  AND StudentGrade IN('G1', 'G2')

  AND (SchoolDept <> '2' OR SchoolDept NOT IN('10','7','8','9')

  --
  :hehe: