Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120050 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
Can we join 3 tables in sql?
How to select 10 records from a table?
How to set up sql*plus output format in oracle?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Cite the differences between execution of triggers and stored procedures?
How many aggregate functions are available there in sql?
What is scalar data type in pl sql?
Which is better trigger or stored procedure?
What is trigger in sql and its types?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is tuple in sql?
What is a sql driver?
Explain the the update statement in sql?
Explain alias in sql?
What schema means?
