I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61305 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / aaaa
SELECT * FROM `student` WHERE class='Six' ORDER BY mark DESC
LIMIT 1,1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you size a resultset?
List the types of recovery model available in sql server?
How to get nth highest salary from employee table.
How column data types are determined in a view?
How to deploy the Report?
Describe the functionalities that views support.
How do we Backup SQL Azure Data?
What is the use of keyword with encryption. Create a store procedure with encryption?
Difference between Sql server reporting services and Crystal reports?
How do I create a stored procedure in sql server?
What are the steps you must follow to hide sql server instances?
How to create a simple table to test triggers in ms sql server?
Explain how you can configure a running aggregate in SSRS?
What is msdb database? : SQL Server Architecture
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
