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

Is trigger a stored procedure?

980

Can we use threading in pl/sql?

1089

how to drop an existing view in mysql? : Sql dba

1102

Explain two easy sql optimizations.

1071

Do ddl statements need commit?

1020

What view means?

1024

How can I make sql query run faster?

1063

What is primary key and foreign key with example?

981

What are variables in pl sql?

1228

What are properties of the transaction?

1045

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

1078

how to escape special characters in sql statements? : Sql dba

1080

What is mutating table error?

1237

How many parts of a pl sql block are optional?

1216

What are the two types of periodical indexes?

987