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 serial sql?

960

What are the basic sql commands?

1074

What is rownum?

966

What is difference between inner join and cross join?

954

How do I use google cloud in sql?

1070

What is number function in sql?

948

What is varchar used for?

1070

what does it mean to have quoted_identifier on? : Sql dba

1134

How to combine two stored procedures in sql?

1206

What is acid property in a database?

1020

What is the difference between view and stored procedure?

953

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2559

What is pl sql in dbms?

934

What is sql in java?

1068

Is sql harder than python?

1079