Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118060 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / niladri saha
into my above solution,u can get whatever position u want,only by giving "n" at the place of "2" at row num. That the right way to write the query. That u can use in dynamically.
Thanks,
like if ur require ment to print empnames of having 3rd max salary,then put 3 at rownum.
Niladri Saha.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Does truncate require commit?
What trigger means?
What is memory optimized table?
How to find 3rd highest salary of an employee from the employee table in sql?
Explain the difference between 'between' & 'and' operators in sql
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
tell us something about heap tables. : Sql dba
Do prepared statements prevent sql injection?
How does postgresql compare to mysql?
What is anonymous block in sql?
What is string data type in sql?
How is debugging done?
How do you break a loop in pl sql?
What are the two different parts of the pl/sql packages?
What is forward declaration in pl sql?
