How to Access Top N Record Group By

Question

I want to access top two record from each group in SQL server. Please tell the query for it ?

Satyapriya Nayak · Answer

Hi Shubham SELECT * FROM (SELECT namedepartmentsalary dense_rank() OVER ( partition by department ORDER BY salary desc) as ranking FROM test1) a WHERE a.ranking Thanks

Shakuntala Gaur · Answer

Hi Please refer to this Link http://stackoverflow.com/questions/6841605/sql-server-get-top-1-of-each-group T hanks

Manvendra Sharma · Answer

SELECT TOP 2 College_Id CAssign_Id Degree_Id FROM ERP_CourseAssign