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 can windows applications connect to sql servers via odbc?

579

What are the triggers in sql?

553

What is coalesce and check constraint in sql server?

539

What is onf in normalization form?

567

Which sql server table is used to hold the stored procedure script?

475

Do you know what are the restrictions that views have to follow?

620

How do I view a stored procedure in sql server query?

533

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

559

which table keeps the locking information? : Sql server administration

517

Mention the differences between substr and charindex in sql server.

513

What is sql profiler. What are the default templates with it? : sql server database administration

515

Describe in brief databases and sql server databases architecture.

524

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

541

What encryption security is available in sql azure?

Define right outer join in sql server joins?

513