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 difference between commit and rollback?
What are the differences between lost updates and uncommitted dependencies?
What are clustered and non-clustered index?
What is thr feature of change data capture?
What are transactions in sql?
What is the difference between index seek vs. Index scan?
what are the different types of SSRS reports?
what's the information that can be stored inside a bit column? : Sql server database administration
Can two tables share a primary key?
How to convert numeric expression data types using the cast() function?
Show Practically Sql Server Views are updatable?
Can we use pragma autonomous_transaction in trigger?
Difference between Inner vs outer joins?
Explain about remote stored procedure?
Why should we go for stored procedures? Why not direct queries?
