Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the syntax for encrypting a column in SQL Server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is 'write-ahead log' in sql server 2000 ?
explain different types of backups avaialabe in sql server? : Sql server database administration
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What happens if we shrink log file in sql server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What are views in ms sql server?
How to use union to merge outputs from two queries together in ms sql server?
what are triggers? : Sql server database administration
What is compression - row-level and page-level compression?
what's sql server? : Sql server database administration
How to read data in a table with "select" statements?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
