Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118534 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
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Define union, minus, union all, intersect ?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
How do you define a foreign key?
Is pl sql a programming language?
State few characteristics of pl/sql?
What is record variable?
Explain the structure of pl/sql in brief.
How can you select unique records from a table?
What is a dirty read sql?
Can we insert data into materialized view?
Explain the significance of the & and && operators in pl sql.
Is subquery faster than join?
What is the purpose of design view?
Is oracle and sql same?
