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 the minimum client footprint required to connect c# to an oracle database?

1072

What is a sub query? Describe its types?

997

What are the ways tablespaces can be managed and how do they differ?

2341

Point out the difference between user tables and data dictionary?

967

How can you use check constraints for self referential integrity?

948

How to use existing values in update statements using oracle?

1044

Can a formula column referred to columns in higher group ?

2490

What is varray?

1110

How to compare dates in oracle sql?

1087

What is an oracle user role?

967

What are the oracle built-in data types?

1042

Are truncate and delete commands same? If so why?

1129

Explain the use of inctype option in exp command.

1014

What are dml statements in oracle?

1075

What is system tablespace?

1076