I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / abhishek srivastava
select top 1 marks from (select top 2 distinct marks from
students order by marks desc)
order by marks
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are the joins in sql server? : sql server database administration
Show Practically Sql Server Views are updatable?
What is implicit mode in sql server?
What is 4nf in normalization form?
What is the recursive stored procedure in sql server?
What are some examples of schemas?
How would you choose between a clustered and a non-clustered index?
What are .mdf files?
Can I save my report as html, excel or word? : sql server management studio
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain aggregate functions?
How many partitions a clustered index has by default in sql server 2012?
What is the Main Difference between ACCESS and SQL SERVER?
How to disable stored procedure sql server?
Differentiate between a local and a global temporary table?