Query specific column for 2 different values in SQL Server

Question

I don't have much experience with database so this might look silly.

I just can't query the same column for 2 different values.

This is what I am trying:

where  b.idIndice = 10 and b.idIndice = 20

I have both values in this column

Thanks

Could you please provide me the sample data?

Deepak.Aggrawal
– Deepak.Aggrawal

2012-12-20 10:40:46 +00:00
Commented Dec 20, 2012 at 10:40 — Deepak.Aggrawal
– Deepak.Aggrawal, Commented Dec 20, 2012 at 10:40

TechDo · Accepted Answer · 2012-12-20 10:38:42Z

4

Do you mean:

SELECT * FROM TBL b WHERE b.idIndice IN (10, 20)

answered Dec 20, 2012 at 10:38

TechDo

18.7k3 gold badges55 silver badges64 bronze badges

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

Comments

xlecoustillier · Accepted Answer · 2012-12-20 10:38:18Z

2

Try :

WHERE b.idIndice = 10 OR b.idIndice = 20

Or

WHERE b.idIndice IN(10, 20)

A value can't be equal to 10 and to 20 at the same time.

answered Dec 20, 2012 at 10:38

xlecoustillier

16.4k15 gold badges64 silver badges88 bronze badges

Comments

SRIRAM · Accepted Answer · 2012-12-20 10:40:02Z

2

use in ()

where b.idIndice in (10,20)

refer here

http://www.techonthenet.com/sql/in.php

answered Dec 20, 2012 at 10:40

SRIRAM

1,8982 gold badges17 silver badges18 bronze badges

Comments

Adeel Ahmed · Accepted Answer · 2012-12-20 10:44:42Z

2

WHERE  b.idIndice = 10 OR b.idIndice = 20

answered Dec 20, 2012 at 10:44

Adeel Ahmed

1,6019 silver badges10 bronze badges

Collectives™ on Stack Overflow

Query specific column for 2 different values in SQL Server

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related