Home Forums Article Discussions Article Discussions by Author Discuss content posted by Andy Riley Using Ranking Functions to Deduplicate Data RE: Using Ranking Functions to Deduplicate Data

  • July 29, 2010 at 5:34 am

    #1199720

    Hi,

    I think we can achieve the same without rank function.

    SELECT * FROM GetMissingItems WHERE RowNumber = 1


    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com