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