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

Answer Posted / hari.sidd

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

Is This Answer Correct ?

1 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Explain the features of oracle?

1020

What is a parameter file in oracle?

1112

What is analyze command used for?

1043

What privilege is needed for a user to connect to oracle server?

977

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2281

What is a named program unit?

1049

How to retrieve data from an cursor to a record?

1073

What are the uses of linked server and explain it in detail?

1042

What are data pump export and import modes?

1048

What are dml statements in oracle?

1075

What are the most common interview questions on ETL Testing for experience?

1118

What is the difference between substr & instr functions?

1200

Explain an integrity constrains?

1121

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1123

How to create a testing table in oracle?

979