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

Is sql harder than python?

1154

What is difference between table and view?

1132

How many tables can you join in sql?

1005

how to include numeric values in sql statements? : Sql dba

1145

Is sql difficult?

1226

how to calculate expressions with sql statements? : Sql dba

1091

What information is needed to connect sql*plus an oracle server?

1075

How do I order columns in sql?

1071

what is the different between now() and current_date()? : Sql dba

1069

What is difference between nchar and nvarchar?

1096

Which join is like inner join?

1085

Explain the purpose of %type and %rowtype data types?

973

What is pl sql in oracle?

1092

Can we rollback delete command?

1035

Can we join more than 2 tables in sql?

1089