Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

student --marks query---sql Expand / Collapse
Author
Message
Posted Thursday, November 04, 2010 8:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 12, 2012 5:40 AM
Points: 27, Visits: 87
Hi Everyone ,
This is a general query about sql.
how to find the 3 rd highest marks in a MARKS coloumn in a sample student data.
Post #1015923
Posted Thursday, November 04, 2010 8:38 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, November 15, 2011 6:31 AM
Points: 2,798, Visits: 7,061
use ROW_NUMBER()

Post #1015927
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse