TSQL: finding unique entries in a single table
- by pcampbell
Consider a table or CTE structured like this:
Name Num
---- ----
Abc 12
Abc 12
XYZ 70
XYZ 80
Bar 50
Bar 55
Foo 44
Foo 44
Baz 88
The requirement is to determine the Name where multiple different Nums exist.
The desired resultset is
Name
----
XYZ
Bar
What TSQL statement would you use to derive this resultset?