Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / raj
select max(sal) from emp where sal < (select max(sal) from
emp)
Is This Answer Correct ? | 31 Yes | 1 No |
Post New Answer View All Answers
What exactly do quotation marks around the table name do?
Please explain joins in oracle?
How to find the duplicate rows count from employees table in oracle?
How does one get the view definition of fixed views/tables?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is a data lock in oracle?
Explain an index segment?
List out the types of joins.
How to download oracle database 10g xe?
How to turn on or off recycle bin for the session?
Explain the use of file option in exp command.
What is recovery manager(rman) backup in Oracle?
How to create additional tablespaces for an new database?
What is a package in oracle?
How to define an anonymous procedure without variables?