I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62833 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / suman
select max(mark) from student where mark <
(select max(mark)from student)
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is the difference between clustered index and primary key?
Can primary key be null?
How to configure and test odbc dsn settings?
How to create stored procedures with parameters in ms sql server?
Explain external key management in sql server 2008
Explain how to send email from sql database?
How to execute a stored procedure in ms sql server?
Can sql server 2016 run on windows 7?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is the significance of null value and why should we avoid permitting null values?
What is the maximum row of a size?
What are number line correlation administrators will use while working with a subquery?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is update_statistics command?
How to reaname table name without using sp_Rename in sql server..?
