TSQL Challenge 50




TSQL Challenge 50 - Extract a subset of the input data by using only a limited set of SQL keywords

The purpose of this challenge is to test your query writing skills with a limited set of TSQL keywords. What is special with this challenge is that you are allowed to use only a given set of TSQL keywords. While this type of restrictions may not be part of a real-world assignment, this will certainly a good test to your TSQL creativity. The idea is to simulate the "limit posit,n" function which doesn't still exist in Ms Sql Server and Sybase.