Answer Posted / shruti
select salary from salarytable orderby salary desc Limit 2,1
First It will arrange all salary in desc order then it will
limit the result using Limit command starting from position
0,1,2 and fetch record 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How to create a simple user defined function in ms sql server?
How can delete duplicate records in cte in sql server?
Will count(column) include columns with null values in its count?
List the data types available in mssql?
What are the kinds of subquery?
Why variables called the most powerful component of ssis?
How to view existing indexes on an given table using sys.indexes?
how to invoke a trigger on demand? : Sql server database administration
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is the recommended total size of your memory optimized tables?
What is a transact-sql statement batch in ms sql server?
What is meant by referential integrity?
how you can get the list of largest tables in a database? : Sql server administration
How can you check the version of sql server?