DateFunction

  • Write a query based on Customer table that returns oldest customer for each city. If there are more than

    1 person with same oldest birth date, show all names for that birth date.

  • kaladharreddy15 (3/9/2010)


    Write a query based on Customer table that returns oldest customer for each city. If there are more than

    1 person with same oldest birth date, show all names for that birth date.

    And what have you done so far to solve this particular problem? I believe that this problem can be solved in SQL Server 2005 using a CTE and the DENSE_RANK windowing function.

    Look them up in Books Online and see what you can come up with.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply