srivani123

 Profile Answers by srivani123 Questions by srivani123

• Nov 15th, 2007

 

hey, here you have to use nested sub queries and also compare the same table by using 2 times. try this command. hopefully it will work

select  a.stuname, a.stumarks, a.total, a.average from student a
where 3=(select count(distinct(b.average))
from student b
where a.average<b.average

cybersavvy

 Profile Answers by cybersavvy 

• Feb 19th, 2009

 

select top 3 * from students order by average desc

prathima

 Profile Answers by prathima 

• Jul 25th, 2009

 

select top 5 avg(rank) from table_name group by rank order by rank desc