SELECT TOP (1) stuMark FROM Student WHERE stuMark

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

Question Posted / siva prakasam

Answer Posted / siva prakasam

SELECT TOP (1) stuMark
FROM Student
WHERE stuMark < (SELECT MAX(stuMark) FROM Student)
ORDER BY stuMark DESC

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to call a function from a stored procedure in SQL Server ?

956

What are the tool windows in sql server management studio? : sql server management studio

1019

How to rename databases in ms sql server?

1128

What is lookup override?

965

What is extent? Types of extents?

1089

Can sql servers linked to other servers?

976

What is the difference between TRUNCATE and DROP?

1067

How to generate create procedure script on an existing stored procedure?

940

What is indexing explain it with an example?

935

What is update locks?

835

Explain what are magic tables in sql server?

948

Mention the command used to rename the database.

948

What is cte (common table expression)?

979

In which files does sql server actually store data?

854

how to use DTS package in 2000,2005,2008 in sql server

1788