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 difference between view and materialized view?
When we should use and scope of @@identity?
List out the difference between union and union all in sql server?
What is Replication?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is a rollup clause?
What is self contained scalar sub query?
How to make a column nullable?
Explain time data type in sal server 2008?
What do you mean by normalisation?
What is an expensive query?
How to set database to be single_user in ms sql server?
Explain transaction server isolation?
What are the dmvs? : sql server database administration
explain declarative management framework (dmf) in sql server 2008?
