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

How much ram can sql express use?

1042

How exception handling is done in advance pl/sql?

1025

What is sql profiling in oracle?

1133

What mean sql?

1054

What is a database? Explain

1179

What is the difference between count 1 and count (*) in a sql query?

1056

what is a composite key ? : Sql dba

1101

Does sql*plus also have a pl/sql engine?

1131

explain mysql aggregate functions. : Sql dba

1032

What is memory optimized?

1135

What is the difference between database trigger and stored procedure?

1141

Is not equal in sql?

1064

How do I sort a table in sql?

1083

How can we find duplicate records in a table?

995

How do I copy a table in sql?

1039