Neha

• May 24th, 2016

 

Code
SELECT max (MARKS ) FROM sp_report WHERE 


MARKS IN (


SELECT TOP 2 * FROM sp_report 


ORDER BY MARKS DESC)

Ankit

• Jun 4th, 2016

 

Code
Select sid, max(maths,chem,phy,engl) as marks


FROM stable


Group by sid;

sandip.daptare

• Jun 6th, 2016

 

Code
SELECT SID, Max(Marksrec)


FROM


(SELECT Sid, 


maths,chems,phys,engi


FROM Marks) AS st


Unpivot


(Marksrec FOR MARKSNO IN( maths,chems,phys,engi)) AS ddd


GROUP BY SID

Suresh

• Jun 20th, 2016

 

Code
SELECT id,greatest(maths,chem,phy,engl) highest_marks FROM marks

Ade

• Jun 23rd, 2016

 

Code
SELECT sid,MAX(maths,chem,phy,engl) "highest_marks"


FROM marks


GROUP BY sid

Paresh

• Jun 24th, 2016

 

Code
 


SELECT sid, Max(Marks) AS highest_marks


FROM sp_report


 Unpivot


(Marks FOR value IN( maths,chem,phy,engl)) AS Score


GROUP BY sid