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 the difference between having clause and where clause?

1048

How can a pl sql block be executed?

934

How do I make my sql query run faster?

925

what is the command line end user interface - mysql? : Sql dba

968

what is a composite primary key ? : Sql dba

1028

What are different types of triggers?

1086

what is the difference between where clause and having clause? : Sql dba

989

what is the difference between inner and outer join? Explain with example. : Sql dba

1014

What is the purpose of design view?

1000

How do I view stored procedures?

959

How do I edit a stored procedure?

981

Is natural join same as inner join?

911

What is auto increment in sql?

1101

What are tables and fields?

1019

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1044