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
- 68548 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sadaq moulani
select top 1 marks from student where marks in(select
distinct top 2 marks from student order by marks desc)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the Ways to improve the performance of a sql azure database?
What is the synonym of join?
How to bind a view to the schema of the underlying tables?
How to insert data into an existing table?
Should you normalize audio?
What is amo? : sql server analysis services, ssas
What is a field name?
What are the events recorded in a transaction log?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Can we shrink data file in sql server?
What are various ways to enhance the ssrs report?
Explain timestamp datatype?
What is ms sql server index?
How to use "begin ... End" statement structures in ms sql server?
Explain about extended stored procedure?
