Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / varun
select sal from emp where rownum=2 order by sal desc;
Is This Answer Correct ? | 6 Yes | 19 No |
Post New Answer View All Answers
What is mdb stand for?
What is count * in sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What are sql constraints?
Which is faster view or stored procedure?
What does desc stand for?
What is %rowtype in pl sql?
What has stored procedures in sql and how we can use it?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are sql queries used for?
Is left join inner or outer?
Why use triggers in sql?
What is pl sql collection?
Explain the purpose of %type and %rowtype data types?
what is sql in mysql? : Sql dba