I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / pravin more
select max(mark) from student where mark <
(select max(mark)from student)
Is This Answer Correct ? | 53 Yes | 14 No |
Post New Answer View All Answers
When would you use it?
What is the difference between varchar and varchar(max) datatypes?
Can sql servers linked to other servers?
What is the full form of dql?
What does it mean if @@cursor_row returns a negative number?
What is trigger and different types of Triggers?
How to create median function?
How to download and install microsoft .net framework version 2.0?
Can you force a query to use a specific index?
What are the steps to insert a table?
What are subquery and its properties?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
what are user defined datatypes? : Sql server database administration
How to use go command in "sqlcmd"?
Explain what is cte (common table expression)?