I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62923 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rupa
Select max(Marks) from Marks where Marks <
(select max(Marks)from Marks)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do I setup a sql server database?
What is a transact-sql statement?
How to find related tables in sql server?
Define right outer join in sql server joins?
What is the difference between deallocate cursor and close cursor?
What is the main purpose of having conversation group?
What are the steps you will take to improve the performance of a poor performing query?
Can you please explain the difference between function and stored procedure?
What is difference between delete & truncate commands?
Explain iaas, paas and saas?
How to stop a loop early with break statements in ms sql server?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is the ‘fillfactor’?
Why use stored procedures in sql server?
How fixed length strings are truncated and padded?
