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

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

1101

What does cursor do in sql?

1018

What type of join is sql join?

981

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2486

how to create a new table by selecting rows from another table in mysql? : Sql dba

1095

What is %s in sql?

1014

What is the size of partition table?

1047

what are the types of subquery? : Sql dba

1105

How to add new employee details in an employee_details table with the following details

1091

What is prepared statement in sql?

1049

What are the subsets of sql?

1133

Does truncate require commit?

972

What are the packages in pl sql?

1009

Show the cursor attributes of pl/sql.

1049

What is view? Can we update view

1439