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

How to change user password in oracle?

973

What is dual table oracle?

920

What is a parameter file in oracle?

1048

How do we create privileges in oracle?

990

How to get a create statement for an existing table?

905

How to define a specific record type?

1034

What are the uses of linked server and explain it in detail?

999

How to add a new column to an existing table with a default value?

964

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2288

How to fetch the row which has the max value for a column?

944

What do database buffers contain?

955

Give the various exception types.

939

When do we use group by clause in a sql query?

990

What are the various types of snapshots ?

970

What is oracle rownum?

883