I have student marks in a student table. I need second
highest mark .Then what will the query for this?
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
What is the difference between Stored Procedures and triggers?
when would you go for denormalization? : Sql server database administration
Can primary key be a foreign key?
What is hot add cpu in sql server 2008?
what is nonclustered index
What is sql or structured query language?
Define inner join? Explain with an example?
How do I make a resultset scrollable?
What is subquery? Explain the properties of a subquery?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
what type of index will get created after executing the above statement? : Sql server database administration
What is entity data services?
What is an index in a database?
Explain activity monitors
Does a server store data?