InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 15:06:51 GMT20http://www.sqlservercentral.com/Forums/Topic1421404-1292-1.aspxThank you ... that did it!-MikeTue, 19 Feb 2013 07:19:10 GMTmikeallenbrownhttp://www.sqlservercentral.com/Forums/Topic1421404-1292-1.aspxYou can use ROW_NUMBER() to achieve the desired results[code="sql"]SELECT *FROM ( SELECT ROW_NUMBER() OVER ( PARTITION BY Client.ID, Patient.SSN ORDER BY StartOfCare ) AS RN, Client.ID, Client.ClientName, Patient.ClientID, Patient.SSN, Patient.StartOfCare, Patient.PrimDiag FROM Client Client INNER JOIN Patient Patient ON Client.ID = Patient.ClientID WHERE Patient.RptYear = 2012 AND Patient.PrimDiag <> 'NULL' AND Patient.PrimDiag <> '' AND Patient.SSN <> '' ) PWHERE P.RN > 1[/code]Tue, 19 Feb 2013 00:26:55 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic1421404-1292-1.aspxIn another thread I had a query where I needed to select only patient new admissions. The query finds the first entry per patient (per SSN actually) and ignores the rest. You can see that here: http://www.sqlservercentral.com/Forums/Topic1421364-1292-1.aspxWhat I need now is to select only re-admissions. So basically excluding the FIRST entry for a patient. If a patient was entered only once then that record is not selected at all.Here is the data:[IMG]http://i132.photobucket.com/albums/q18/mikeallenbrown/Public%20Album/Ashampoo_Snap_20130218_19h57m39s_013__zps9eda67f5.png[/IMG]Based off of the above data I'd expect to see ONLY line 5 and 7 .... patient with SSN of 123-12-3123 just happens to be the only duplicates in this sample but in a live database there could be many duplicates. Line 8 is the first admit so it too is excluded.Does that make sense? ....please let me know if further clarification is need. I wouldn't consider myself an "advanced" SQL use but I'm learning fast! :-DThank you in advance.-MikeMon, 18 Feb 2013 19:12:47 GMTmikeallenbrown