Here's the modified query to find the Maximum and Second Maximum value in a Group/Category using a CTE in SQL Server 2005/2008
Query to fetch the highest and second highest marks in each Subject
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|