Tag Archives: rank()

t-SQL to find top X toppers in each subject from marks table

rank() function in SQL can be used to find such results in SQL! Here is the simple example for FUN 🙂 Reference/ New features in SQL 2012: https://vijredblog.wordpress.com/2014/02/18/tsql2012-less-frequently-used-features-revision-01/

Posted in Script, SQL, SQL Query | Tagged , , , | Leave a comment