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

Will you be able to store pictures in the database?explain.

546

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1933

How to delete a column in an existing table?

604

What happens if you lost a data file?

594

How a tablespace is related to data files?

589

What is execute immediate in oracle?

557

How to export data to a csv file?

636

Where is the export dump file located?

577

What is a oracle database?

620

What is an oracle table?

568

material view and view disadvantages?

643

How would you begin to troubleshoot an ORA-3113 error?

1612

What is pragma autonomous transaction in oracle?

536

What language does oracle use?

608

Explain the use of show option in imp command.

650