I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61309 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rias
Select MIN(MARK) from student where mark in (select Top 2
mark from student order by mark desc)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How does using a separate hard drive for several database objects improves performance right away?
What is database replication?
How to update multiple rows with one update statement in ms sql server?
How do I create a stored procedure in dbml?
What is the Disadvantage of indexed sequential file.
Write an SQL query to obtain the 2nd highest salary.
Is null in sql server?
What are extended events in sql server?
What are the benefits of filtered indexes?
What are the disadvantages of using the stored procedures?
What is the difference between a check constraint and a rule?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is tempdb database? : SQL Server Architecture
Why are you getting errors when creating a new odbc dsn?
What happens if date-only values are provided as date and time literals?
