1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
Answer Posted / hema
Select sal from emp a where 2=(select count(distinct sal)
from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Please explain drop constraint oracle?
How translate command is different from replace?
How to view the data files in the current database?
How to check your oracle database 10g xe installation?
What privilege is needed for a user to create tables in oracle?
What is a nested table and how is it different from a normal table?
In which language oracle has been developed?
What is the usage of merge statement?
What is a table in oracle?
How does one get the view definition of fixed views/tables?
How to concatenate two text values in oracle?
How does the on-delete-cascade statement work?
Is oracle a programming language?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What are the ways tablespaces can be managed and how do they differ?