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

What encryption security is available in sql azure?

What stored procedure can you use to display the current processes?

568

Explain table valued parameters in sql server? Why tvp used?

646

List some advantages and disadvantages of stored procedure?

658

Explain in details security in SQL azure?

107

what is a schema in sql server 2005? : Sql server database administration

601

What is a matrix in ssrs?

105

What is tcl in sql server?

744

What are diverse clauses that form a part of sql?

681

What is b tree index?

596

why would you use sql agent? : Sql server database administration

624

What is the difference between a function and a trigger?

673

What is index, cluster index and nonclustered index?

596

plss anybody specify tha constrian management system in dbms

1684

What are the various editions of sql server 2017 that are available in the market?

576