[SQL Server] Finding and picking from Duplicates... |
| Finding and picking from Duplicates... Posted: 04 Oct 2013 04:31 AM PDT This should be simple but I' having a hard time wrapping my head around this one late on a friday afternoon.I have a table containing people and except for one or two fields, the entire record could be a duplicate and should be treated as so. For example:FirstName, LastName, Address, City, State, SSN, SomeNumber***************************************************John, Doe, 123 Street, Atlanta, GA, 3000, 123456789, 001John, Doe, 123 Street, Atlanta, GA, 3000, 123456789, 004John, Doe, 123 Street, Atlanta, GA, 3000, 123456789, 007How can I write a select statement to just get the most recently created record like:John, Doe, 123 Street, Atlanta, GA, 3000, 123456789, 007??? |
| SQL Error message - explanation Posted: 03 Oct 2013 11:26 PM PDT What does this error message mean when a application is connected to a SQL database?'Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index'Thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment