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

what is myisam? : Sql dba

1001

How to make a copy values from one column to another in sql?

985

Can two tables have same primary key?

917

What is the difference between a query and a report?

903

What are dml commands?

943

What is the difference between database trigger and stored procedure?

1007

What is left join in postgresql?

998

What is sql procedures and functions?

956

how can you see all indexes defined for a table? : Sql dba

936

How do I run a sql query?

969

when MSQL8.0 is in market

2016

What is identity column in sql server?

988

What is sql performance tuning?

868

How many types of normalization are there?

901

What is delimiter in pl sql?

992