SELECT sal FROM EMPLOYEES WHERE sal>(SELECT avg(sal) FROM EMPLOYEES);

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

Question Posted / gop

Answer Posted / gop

SELECT sal FROM EMPLOYEES WHERE sal>(SELECT avg(sal) FROM
EMPLOYEES);

Is This Answer Correct ?

47 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the use of sql trace?

898

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

950

How many tables can you join in sql?

901

Can we call a function containing dml statements in a select query?

920

What does the argument [or replace] do?

1017

Explain normalization and what are the advantages of it?

892

Does inner join remove duplicates?

888

How can you get sql*loader to commit only at the end of the load file? : aql loader

967

How do sql triggers work?

989

what is 'mysqladmin' in mysql? : Sql dba

974

what is an index? : Sql dba

933

Can we call procedure in select statement?

976

What is full join in sql?

939

What does trigger mean in slang?

1007

What does cursor do in sql?

971