select ename,esal from emp_mast where esal > (select avg (esal) from em

query to retrive the employees whose sal is greater than avg
sal

Question Posted / badchip

Answer Posted / badchip

select ename,esal from emp_mast where esal > (select avg
(esal) from emp_mast group by esal);

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many triggers can be applied to a table?

1125

What does count (*) do in sql?

1050

What is a pl/sql block?

1329

Why having clause is used in sql?

1020

How can we optimize a sql query?

1109

Define select, insert, create, delete, update, drop keywords

1094

Can instead of triggers be used to fire once for each statement on a view?

1006

Explain the the update statement in sql?

1105

Does mysql support pl sql?

1232

How to use boolean type in select statement?

1139

What has stored procedures in sql?

1104

What is not in sql?

999

what is “go” in t-sql? : Transact sql

1158

Does sap use sql?

1041

What is sql profiler in oracle?

1160