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

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

Please Help Members By Posting Answers For Below Questions

What is a cube? : sql server analysis services, ssas

993

What is the difference between a unique key and primary key?

946

Explain powershell included in sql server 2008?

1051

What is the web service used for reporting services?

123

What is the difference between locking and multi-versioning?

985

How each E-R model constructs can be mapped to the relational model?

999

What are the different types of upgrades that can be performed in sql server?

1175

What is data compression?

990

Can you force a query to use a specific index?

942

What is the name of the Database which IBM mainframe uses?

982

What is database replication? What are the different types of replication you can set up in sql server?

958

How to remove duplicate rows from table?

1243

How to modify the underlying query of an existing view?

989

What is the sql case statement used for?

1093

What command is used to rename the database?

1007