Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Write query to fetch second maximum salary from employee table.

Answers were Sorted based on User's Feedback



Write query to fetch second maximum salary from employee table...

Answer / ritesh

select max(salary) from emptable where salary < (select max(salary) from emptable);

Is This Answer Correct ?    8 Yes 0 No

Write query to fetch second maximum salary from employee table...

Answer / vijayalakshmi

select  top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name

Is This Answer Correct ?    4 Yes 0 No

Write query to fetch second maximum salary from employee table...

Answer / abhishekjaiswal

select a.last_name,a.salary from employees a where 3=(select count(*) from employees b where b.salary>a.salary) order by a.salary desc.
<<<<<<<<<[N-1]>>>>>>>>>>

Is This Answer Correct ?    3 Yes 1 No

Write query to fetch second maximum salary from employee table...

Answer / santosh kumar

select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More Oracle General Interview Questions

what is the syntax of update command?

3 Answers   Semantic Space,


Why do you create or replace procedures rather that drop and recreate.

0 Answers  


how do u setup a replication site?

0 Answers  


Can you have more than one content canvas view attached with a window ?

0 Answers   Oracle,


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1 Answers  






How to retrieve the count of updated rows?

0 Answers  


What is a cluster Key ?

2 Answers  


Can a View based on another View ?

3 Answers  


How to create a stored function in oracle?

0 Answers  


What is a nested table?

0 Answers  


t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,


Explain the features of oracle?

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)