Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 68733 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
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
What is the server name for sql management studio?
What is a result set object returned by mssql_query()?
What is self contained scalar sub query?
Can sql servers linked to other servers?
What is master database? : SQL Server Architecture
How to convert binary strings into integers in ms sql server?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is sub query and its properties?
How to loop through result set objects using odbc_fetch_row()?
Are resultset updatable?
What is dknf in normalization form?
Tell me something about security and sql azure?
where can you add custom error messages to sql server? : Sql server administration
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is schemabinding a view?
