I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 63085 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / maheswar reddy s
select top 1 * from (select top 2 marks from student order by marks desc)a order by marks
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what is analysis service repository?
What are the basic functions for master, msdb, model, tempdb and resource databases?
Do you know the cursor optimization tips?
Explain about integration services of Microsoft SQL server?
How do I completely remove sql server instance?
What is ssl in sql server?
What happens to a statement batch if there is a compilation error?
How do you delete duplicate rows in sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
what are the reporting service components in SSRS?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What information is maintained within the msdb database?
What is the maximum length of an alert name?
When we should use and scope of @@identity?
Explain about local stored procedure?
