SELECT ENAME FROM EMPLOYEE WHERE ESAL=MAX(ESAL);

How to select the name of employee who is getting maximum
sal with out using subquery

Question Posted / hari.sidd

15 Answers
16029 Views
I also Faced
E-Mail Answers

Answer Posted / hari.sidd

SELECT ENAME
FROM EMPLOYEE
WHERE ESAL=MAX(ESAL);

Is This Answer Correct ?

1 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is tns service name?

1126

Can we use bind variables in oracle stored procedure?

948

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

How to store pictures on to the database?

973

What is a database table in oracle?

1021

Difference between varchar and varchar2 data types?

1184

What is truncate oracle?

971

Explain mutating triggers.

1027

What is a data dictionary and how can it be created?

1150

What is a nvl function? How can it be used?

1029

Where are the settings stored for each instance in oracle?

1105

Does oracle database need java?

1004

How to execute the package in oracle?

1081

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2061

How to use values from other tables in update statements using oracle?

1079