Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 67352 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
select Top 1 marks from students where marks in(select Top
2 marks from students order by marks desc)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What happens if you insert a duplicate key for the primary key column in ms sql server?
Difference between report and query parameter.
What are the different types of indexes?
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
How can we get count of the number of records in a table?
How do I view a trc file?
List the different normalization forms?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What are distinctive joins find as a part of sql?
Do you know sql server 2008 backup compression?
Explain difference between cross join and full outer join?
Write a SQL query to make a column as unique?
How do I find the query plan in sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What are the requirements on sql server network connections?
