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 call a stored function in oracle?

1028

How can windows applications connect to oracle servers?

1070

What is the quickest way to fetch the data from a table?

1066

What is an Oracle index?

1664

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

2362

What are temporal data types in oracle?

1130

When system tablespace is created?

1050

Explain oracle left join with an example?

1022

Give the different types of rollback segments.

1039

What is system tablespace?

1108

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2129

What privilege is needed for a user to delete rows from tables in another schema?

1081

How to empty your oracle recycle bin?

1034

What is tns entry?

1166

How can we find out the duplicate values in an oracle table?

1060