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

tell us something about heap tables. : Sql dba

1077

What is rowtype?

999

When are we going to use truncate and delete?

965

What is scalar and vector?

987

What are sql functions? Describe the different types of sql functions?

1122

What are the limitations of sql express?

1048

Is inner join same as self join?

1107

What is trigger in sql? Explain

976

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1093

Why do we use procedures in sql?

1059

What is difference between rank () row_number () and dense_rank () in sql?

1090

What are the parameter modes supported by pl/sql?

1082

How to change sql*plus system settings?

1042

What does (+) mean in sql joins?

1046

What operating systems are supported by oracle sql developer?

938