How do I specify multiple values in SQL query where clause?

Question

My current query is:

Select Distinct
  SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor
from
  SomeDay, SomeDayEvent
where
  SomeDay.SomeDayID != 4,3,2,1;

You seem to have forgotten to ask a question.

Martin Smith
– Martin Smith

2012-02-21 12:26:13 +00:00
Commented Feb 21, 2012 at 12:26 — Martin Smith
– Martin Smith, Commented Feb 21, 2012 at 12:26

YXD · Accepted Answer · 2012-02-21 12:25:28Z

8

I think you want:

Select Distinct
  SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor
from
  SomeDay, SomeDayEvent
where
  SomeDay.SomeDayID not in (4,3,2,1)

answered Feb 21, 2012 at 12:25

YXD

32.6k15 gold badges79 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ben · Accepted Answer · 2012-02-24 12:04:09Z

0

This is your problem based only.

Select Distinct
SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor
from 
SomeDay, SomeDayEvent 
where
SomeDay.SomeDayID>4;

edited Feb 24, 2012 at 12:04

Ben

53.1k36 gold badges133 silver badges156 bronze badges

answered Feb 21, 2012 at 12:43

Rajesh_Bangalore

6095 silver badges21 bronze badges

1 Comment

Ben Over a year ago

I quite like the answer but while that works for this particular instance of this particular problem what happens when he doesn't want id 5?

Kokarn · Accepted Answer · 2012-02-21 12:28:08Z

-1

That should be something like

Select Distinct
   SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor
from  
   SomeDay, SomeDayEvent
where
   SomeDay.SomeDayID != 4
and
   SomeDay.SomeDayID != 3
and
   SomeDay.SomeDayID != 2
and
   SomeDay.SomeDayID != 1;

answered Feb 21, 2012 at 12:28

Kokarn

12 bronze badges

Collectives™ on Stack Overflow

How do I specify multiple values in SQL query where clause?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related