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 clustered index sql?

963

Are sql database names case sensitive?

962

How can I make sql query run faster?

981

Which function is used to return remainder in a division operator in sql?

1100

What are different types of queries in sql?

1074

Explian rowid, rownum? What are the psoducolumns we have?

965

What does rownum mean in sql?

992

What is delimiter in pl sql?

1018

What is the life of an sql statement?

986

What is sql data?

952

What is scope of pl sql developer in future?

980

Can we commit in trigger?

943

How do I edit a stored procedure?

963

what is a unique key ? : Sql dba

1059

what is cursor. write example of it. What are the attributes of cursor.

1344