SQL вопросик...

[alkapin]

How do I select a list of DUPLICATE values from field F of table T?
F can be equal NULL as well.

Thanks.

PS: MSSQL 2000

[SVK]

How do I select a list of DUPLICATE values from field F of table T?
F can be equal NULL as well.

select F
from (select F, count(*) as S from T group by F) as X
where S > 1;

или

select F, count(*)
from T
group by F
having count(*) > 1;

P.S. Не понял, какая роль NULL для F?

[zVlad]

What about:


Select F, Count(*) From T Group By F Having Count(*) > 1

Правда это для DB2, но может быть на MS SQL это также?

[alkapin]

Спасибо.