Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116062 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
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
How do we accept inputs from user during runtime?
What is the difference between truncate and drop statements?
Can a foreign key be a duplicate?
What does an inner join do?
How to add, remove, modify users using sql?
How can triggers be used for the table auditing?
how to select unique records from a table? : Sql dba
What are the different types of tables in sql?
What is right join in sql?
what is bdb (berkeleydb)? : Sql dba
When you have to use a default "rollback to" savepoint of plvlog?
what is a table in a database ? : Sql dba
What is pessimistic concurrency control? : Transact sql
How delete all data from table in sql?
