Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / keerthi
select(max(salary)
from employee
where sal>max salary&salary<max salary-1;
if you say no to my answer plz correct me.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data block in Oracle?
How to start a new transaction in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Is insert autocommit in oracle?
What is oracle used for?
How to establish administrator authentication to the server?
Please explain oracle left join with an example?
What privilege is needed for a user to query tables in another schema?
What is the usage of control file in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Can we write insert statement in function in oracle?
How to use windows user to connect to the server?
What is snapshot is too old? Give and example for better understand.
What are triggers in oracle?