How to Select second Maximum salary in a Table ?
Answer Posted / kuldeep singh
select max(sal) from emp where sal not in (select top2 sal from emp order by sal desc)
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Which environment variables are absolutely critical in order to run the OUI?
if you ctreate table identity
How many types of tables are there in oracle?
How to run create database statement?
What are operators in oracle?
What do you mean by cdb and pdb in oracle 12c?
State the difference between a primary key and foreign key?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is the database name in oracle?
Name the three major set of files on disk that compose a database in Oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What to do if the startbd.bat failed to start the xe instance?
what is meant by magic query
How will you identify oracle database software release?
Why does oracle 9i treat an empty string as null?