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 transaction server auto commit?

1114

Explain steps of normalization?

1061

Can select statements be used on views in ms sql server?

1104

Can we do dml on views?

1015

Define normalisation?

1155

what is unique and xaml nonclustered index

1097

What is the dbcc command and why is it used?

1105

Tell me about builtinadministrator?

1041

What is the use of floor function in sql server?

1125

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1085

What is the bookmark lookup and rid lookup?

1034

What is data block and how to define data block size?

1077

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1095

How to convert a unicode strings to non-unicode strings?

1151

Explain filtered indexes?

1039