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 create a new user account in oracle?

1021

Explain a synonym?

1032

What is oracle latest version?

1096

What is a tns service name?

1009

What is the best way to do multi-row insert in oracle?

1067

How to export your connection information to a file?

1133

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2357

How to select all columns of all rows from a table in oracle?

1053

How do I learn what codesets are available in oracle?

1039

State all possible different index configurations a table can possibly have?

1007

How to start your 10g xe server?

1042

what are bitmap indexes? How does they work?

2251

Point out the difference between user tables and data dictionary?

983

How to create a new tablespace in oracle?

987

Explain overloading. Can functions be overloaded?

987