Simple T-SQL question to help a newbie

Question

Simple T-SQL question to help a newbie

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Aggie D SSC-Addicted Points: 443 More actions · Answer 1

If I am reading what you are writing correctly, you would like the results to only return Baker, because that name only appears 1 time. Here is the code that will do that. just copy it into query analyzer and it should work.

declare @t table (

tid int,

tname varchar(5)

)

INSERT INTO @T (tid, tname) VALUES (2,'Baker')

INSERT INTO @T (tid, tname) VALUES (3,'Smith')

INSERT INTO @T (tid, tname) VALUES (4,'Smith')

INSERT INTO @T (tid, tname) VALUES (5,'Smith')

select distinct tname from @t group by tname having count(tname) = 1

Aggie D SSC-Addicted Points: 443 More actions · Answer 2

forgot to delete the distinct from the query. It is redundant.

javawanabe Valued Member Points: 69 More actions · Answer 3

javawanabe

Valued Member

Points: 69

February 26, 2004 at 8:35 am

#495877

Yup, that did it. Thanks David

RandyB SSCommitted Points: 1565 More actions · Answer 4

Why not:

SELECT COUNT(*), Surname FROM Employees

GROUP BY Surname

HAVING COUNT(*) = 1

SQLBill SSC Guru Points: 51440 More actions · Answer 5

Randy,

Your suggestion returns too much. It returns the count (SELECT COUNT(*)) which isn't what the poster requested.

-SQLBill