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

What is a user role in oracle?

1183

Explain what are clusters?

1156

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

Explain oracle insert into command?

1158

What is a system tablespace?

1132

How to use windows user to connect to the server?

1045

Write a syntax for update query in oracle?

1073

Can we convert a date to char in oracle and if so, what would be the syntax?

1062

What are a collation and state the different types of collation sensitivity?

1241

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4414

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1975

What happens to the data files if a tablespace is dropped?

1107

What do you understand by database schema and what does it hold?

1298

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2335

What is where clause in oracle?

1076