Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 91254 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / sikindar
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to drop an existing view in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Explain parameter file in oracle.
How do I know if oracle client is installed on windows?
What are joins, explain all types of joins?
How to create lov dynamically at runtime & attach to text field?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to create a new table in oracle?
How to initialize variables with default values?
How to sort output in descending order in oracle?
How index is implemented in oracle database?
How do you tell what your machine name is and what is its IP address?
What is merge statement used for?
What is a database table in oracle?
