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

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1132

how to define testing of network layers? : Sql server database administration

972

Can group functions be used in the order by clause in ms sql server?

1013

What is sql service broker?

982

How can I know what locks are running on which resource?

953

What is the process of indexing?

1007

Can we store videos inside the sql server table?

978

How to connect a database with sql express.?

1058

What is database mirroring?

1112

What is the use of stored procedure?

937

What is the difference between Clustered and Non-Clustered Index?

1057

What are different type of Collation Sensitivity?

1001

How will you find out if there are expensive SQL statements running or not?

1014

Tell me what is difference between view and materialized view?

935

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169