Select max(Marks) from Marks where Marks < (select max(Marks)from Marks

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

Question Posted / rupa

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

Answer Posted / rupa

Select max(Marks) from Marks where Marks <
(select max(Marks)from Marks)

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between delete table and truncate table commands? : Sql server database administration

1034

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1848

What is pessimistic concurrency?

975

How do I create a stored procedure in sql server?

1034

Explain the phases a transaction has to undergo?

1057

What is named calculation? : sql server analysis services, ssas

982

Explain DBCC?

961

What is executereader?

952

What is attribute relationships, why we need it? : sql server analysis services, ssas

967

What is molap and its advantage? : sql server analysis services, ssas

986

Explain what is “asynchronous” communication in sql server service broker?

917

What is the difference between Stored Procedures and triggers?

1082

What is rs.exe utility?

156

Explain external key management in sql server 2008

889

What is the difference between nvl and nvl2?

977