I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / sanah
select top 1 marks from marks where marks
<(select max(marks) from marks) order by 1 desc
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is the current pricing model of SQL Azure?
What is tablix?
What is difference between line feed ( ) and carriage return ( )?
Can you name some of the dml commands in sql?
What is lookup override?
How to join two tables in a single query in ms sql server?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How do I schedule a sql server profiler trace?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is transact-sql language?
Where are sql server usernames and passwords stored in the sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How do you check sql server is up and running?
What is user defined datatypes and when you should go for them?
Write a SQL queries on Self Join and Inner Join.