I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / ravindra singh
select b.marks from (select distinct marks from student)
a,(select distinct marks from student) b
where a.marks >= b.marks
group by b.marks
having count(b.marks)=3
Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What is a user-defined function in the sql server and what is its advantage?
What stored by the master? : sql server database administration
What is sql stored procedure?
what's the difference between delete table and truncate table commands? : Sql server database administration
Explain the difference between delete,drop and truncate in SQL Server?
Explain nested trigger in sql?
Explain datetimeoffset data type in sal server 2008?
what's the difference between a primary key and a unique key? : Sql server database administration
How many replicas are maintained for each SQL Azure database?
How do I perform an unattended install of sql server 2000?
What is openxml in sql server?
How can you manage sql azure security?
Explain the properties of the relational tables?
Can binary strings be used in arithmetical operations?
Explain what is “asynchronous” communication in sql server service broker?