hi Im SureRishi SELECT * FROM Employee E1 WHERE (4-1) = ( SELECT COU

find out first highest salary?

Question Posted / suren

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

Please Help Members By Posting Answers For Below Questions

What is transport network substrate (tns) in oracle?

585

Explain the difference between sql and oracle?

578

What do you mean by merge in oracle and how can you merge two tables?

522

Explain the difference between a procedure and a function? What do you understand by those terms?

620

How many types of auditing in Oracle?

566

What are the attributes of cursor?

587

What are the database administrators utilities available?

576

Explain drop constraint oracle?

589

How to best split csv strings in oracle 9i?

584

Can we connect to ORACLE db using Windows Authentication?

722

Calculate difference between 2 date / times in oracle sql?

570

Describe an oracle table?

568

How to login to the server without an instance?

618

Can select statements be used on views in oracle?

591

How to define an oracle sub procedure?

595