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 use of attributehierarchyenabled? : sql server analysis services, ssas
What is the purpose of the master database?
How to provide values to stored procedure parameters in ms sql server?
How to include date and time values in sql statements?
Can group by and orderby be used together?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How to send a ssrs report from ssis?
What program is used to store the data source file?
What is a trigger in sql server?
Explain the truncate command?
What is resultset concur_updatable?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is truncate table?
Tell me about joins in database system and explain each in detail.
What is the difference between ddl and dml?
