[dba-SQLServer] Top1

JWColby jwcolby at colbyconsulting.com
Fri Jan 26 09:01:06 CST 2007


I have a dataset where I have multiple addresses, multiple people living at
the same address.  "Address" is defined as "Address1,zip5,zip4".  Is it
possible to directly create a result set with just the first record at each
address?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 



More information about the dba-SQLServer mailing list