Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118806 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / lakshminarayana reddy
select rownum,empno,ename,job,sal from emp(select
rownum,empno,ename,job,sal from emp order by sal desc) grop
by rownum,empno,ename,job,sal having rownum=2;
| Is This Answer Correct ? | 7 Yes | 10 No |
Post New Answer View All Answers
What are the disadvantages of not performing database normalization?
what is union, minus and interact commands? : Sql dba
What is rownum and rowid?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What does 0 mean in sql?
What is an emotional trigger?
What is the difference between microsoft access and sql?
Is vs as in pl sql?
How to set up sql*plus output format in oracle?
What are the different schemas objects that can be created using pl/sql?
What is embedded sql with example?
what is union? : Sql dba
What is meant by <> in sql?
What is a data definition language?
What is procedure and function?
