select mark from student s where 1=(select count(*) from student s1 where

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / kunal sain

37 Answers
68739 Views
NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
E-Mail Answers

Answer Posted / kunal sain

select mark from student s
where 1=(select count(*) from student s1
where s1.mark<s.mark);

Is This Answer Correct ?

5 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of stored procedure?

941

What is difference between views and stored procedures?

991

What is Sqlpaging in SqlServer 2005 ?

1069

What encryption security is available in sql azure?

101

How does Report Builder support Analysis Services cubes?

154

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

958

How do I completely remove sql server instance?

1104

Define outer join?

1003

What is snapshot parameter in ssrs?

150

How to find the source of a table in sql server?

998

What is service broker?

1005

Can sql servers linked to other servers like oracle?

954

What are different types of roles provided by ssrs?

150

What is a transact-sql statement?

1065

Tell me what is log shipping?

977