I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / kumaravel
try using this...
select top 1 from student where marks in (select top 2 from
student order by marks desc)
| Is This Answer Correct ? | 16 Yes | 10 No |
Post New Answer View All Answers
Explain syntax for viewing trigger?
what is the system function to get the current user's user id? : Sql server database administration
Does windows server 2016 come with sql server?
How do I debug a stored procedure in sql server?
What is primary key and example?
What is reference section?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the architecture of ms sql reporting service?
How many databases Microsoft SQL server provides?
What are the key configuration files for sql server reporting services ?
How to retrieve field values using mssql_result()?
Does a full backup include transaction log?
List some major differences between triggers and stored procedures?
What is a join in sql? What are the types of joins?
Explain system rowset functions?