wikidba.net
Select rows with TIES option
Its very common when a Developer/DBA wanted to see sample of few records, commonly they use SELECT TOP N records from a table being ordered by a column, the query look like as SELECT TOP N [COLUMN…