select ename from employee where sal=(select disinct(max(sal) from employee

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

Question Posted / rushi

Answer Posted / rushi

select ename from employee where sal=(select disinct(max(sal) from employee));

Is This Answer Correct ?

2 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What are named parameters?

1077

Will you be able to store pictures in the database?

1095

How to define a data field as not null?

1094

How to run the anonymous block again?

1115

Explain the use of inctype option in exp command.

1017

What do database buffers contain?

1008

What is meant by a deadlock situation?

1095

Can we call procedure inside function in oracle?

1063

What is the difference between sharding and partitioning?

968

What is a procedure in oracle?

1159

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2025

What do you understand by a database object?

1042

What is an oracle transaction?

1117

What is the usage of control file in oracle?

1074

What is the recommended interval at which to run statspack snapshots, and why?

2899