find out first highest salary?
Answer Posted / suren
hi Im SureRishi
SELECT *
FROM Employee E1
WHERE (4-1) = (
SELECT COUNT(DISTINCT(E2.Salary))
FROM Employee E2
WHERE E2.Salary > E1.Salary)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is transport network substrate (tns) in oracle?
Explain the difference between sql and oracle?
What do you mean by merge in oracle and how can you merge two tables?
Explain the difference between a procedure and a function? What do you understand by those terms?
How many types of auditing in Oracle?
What are the attributes of cursor?
What are the database administrators utilities available?
Explain drop constraint oracle?
How to best split csv strings in oracle 9i?
Can we connect to ORACLE db using Windows Authentication?
Calculate difference between 2 date / times in oracle sql?
Describe an oracle table?
How to login to the server without an instance?
Can select statements be used on views in oracle?
How to define an oracle sub procedure?