Write query to fetch second maximum salary from employee table.
Answers were Sorted based on User's Feedback
Answer / ritesh
select max(salary) from emptable where salary < (select max(salary) from emptable);
|Is This Answer Correct ?||8 Yes||0 No|
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|
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|
what is the syntax of update command?
Why do you create or replace procedures rather that drop and recreate.
how do u setup a replication site?
Can you have more than one content canvas view attached with a window ?
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?
How to retrieve the count of updated rows?
What is a cluster Key ?
Can a View based on another View ?
How to create a stored function in oracle?
What is a nested table?
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.
Explain the features of oracle?