Query repeated valus in one table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Query repeated valus in one table

Author

Topic

csu
Starting Member

2 Posts

Posted - 2010-07-16 : 17:59:01

Table A has the following records:
No Desc.
1 , A
1 , B
1 , C
2 , A
2 , B
3 , A
3 , C

I need to get the following:

2

(only the No that don't have C under the desc.)

Thanks for any suggested query

singularity
Posting Yak Master

153 Posts

Posted - 2010-07-16 : 19:23:40

select distinct no
from yourtable a
where not exists (select * from yourtable b where b.desc = 'C' and a.no = b.no)