I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / jyoti bikash panda
select a.marks from student a where(select count(b.marks)
from student b where a.marks<=b.marks)=2
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to convert binary strings into integers in ms sql server?
What is logon trigger?
What is the difference between dataadapter and datareader?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How to get a list of all tables with "sys.tables" view in ms sql server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to convert a table data in XML format in sql server?
Explain a checkpoint?
What do you understand by check constraint in sql server?
How can you find out which stored procedures are recompiling?
What is ssrs?
What is the difference between push and pull subscription? : sql server replication
What do you understand by recursive stored procedures?
Explain how to integrate the ssrs reports in application?
Define model database?