I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62984 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
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 is a mixed extent? : Sql server administration
Can we return Data from 4(more than 1) tables in stored procedure?
What is the default value of an integer data type in sql server 2005?
What are the types of indexes?
Can you explain different types of locks in sql server?
How to create new table with "create table" statements?
How to generate create view script on an existing view?
Explain about integration services of Microsoft SQL server?
What is the maximum number of index per table?
How do you start single user mode in clustered installations?
Explain the ways to controlling cursor behavior?
What is inline variable assignment?
Is oracle faster than sql server?
What is primary key, unique key, and foreign key?
What is DCL?
