SQL>SELECT ENAME,SAL FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP);

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

Question Posted / amit

Answer Posted / amit

SQL>SELECT ENAME,SAL FROM EMP
WHERE SAL>(SELECT AVG(SAL) FROM EMP);

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how to use case expression? : Sql dba

1031

What is the difference between clustered and non-clustered indexes?

1093

Are sql database names case sensitive?

1009

How many disk partitions should I have?

991

What is nvarchar max in sql?

1022

What is snowflake sql?

1079

What is #table in sql?

1108

how to check server status with 'mysqladmin'? : Sql dba

1083

What is a primary key? Explain

981

Does sql use python?

1038

Where can I learn sql for free?

998

How can I change database name in sql?

1087

What are the uses of sysdate and user keywords?

1105

What is function and procedure in pl sql?

1050

What does seeding a database mean?

973