Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 4121
-
select only those rows where ssn matches previous ssn
I think group by clause should have Person.last_name, Person.first_name and in select clause you should take out distinct i-e count(person.ssn). SELECT Person.last_name, Person.first_name, count (person.ssn) FROM Qdb.dbo.Person Person, Qdb.dbo.ReceivableAccount...- 4121
- Post #4
- Forum: Sybase: Adaptive (SQL) Server
