Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116141 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / deven
select top 1 salary from emp where salary <>(
select top 1 salary from emp order by salary desc) order by
salary desc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the types of variables use in pl sql?
What is rtm in testing?
Explain cursor types?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Show code of a cursor for loop.
What are string functions in sql?
Does access use sql?
What is rollback?
Why is the cursor important?
How to run sql statements with oracle sql developer?
What is %rowtype in pl sql?
Is delete faster than truncate?
What are sql objects?
What is the process of debugging?
Describe types of sql statements?
