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

Can you upgrade sql express to full sql?

1078

What is an intersect?

1111

Which command is used to call a stored procedure?

1010

explain primary keys and auto increment fields in mysql : sql dba

983

Determine if oracle date is on a weekend?

1050

What is the maximum size of sqlite database?

1117

How does stored procedure reduce network traffic?

1017

What is raw datatype in sql?

1052

Which sql statement is used to delete data from a database?

968

What is oracle pl sql developer?

990

how to use myisamchk to check or repair myisam tables? : Sql dba

972

What is the use of <> sql?

985

What do you mean by stored procedures? How do we use it?

1002

Can we debug stored procedure?

1032

How do you add a column to a table?

1066