I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / b.bathakaraithangam,giri
select * from student where mark=(select max(mark) from
student where mark not in (select max(mark) from student))
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what information is maintained within the msdb database? : Sql server administration
How to convert a table data in XML format in sql server?
Explain system rowset functions?
What are different types of replication in sql server?
Do you know what is normalization of database? What are its benefits?
What is create statement?
What is scheduled job and how to create it?
Which are the new data types introduced in sql server 2008?
Can you import Microsoft Excel data to SSRS?
what is the primary use of the model database? : Sql server administration
what is a transaction? : Sql server database administration
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What is difference between inner join and full join?
What is built-in/administrator?
List out different types of normalizations in sql server and explain each of them?