Ryear Rexam Appeared Passed 2009 MP 100 80 2010 MP 120 100 2010 HS 100 90 2011 MP 120 90 2011 HS 120 100 2012 MP 100 100 2012 HS 120 100
Select top 2 * from tablename where Rexam='MP' order by Ryear desc
SELECT TOP 2 * FROM MyTable WHERE Rexam = 'MP' ORDER BY Ryear DESC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)