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 a native sql query?

701

What is the purpose of a secondary key?

681

Explain what is a column in a table?

764

Does view contain data?

788

How to know the last executed procedure?

809

When can we use the where clause and the having clause?

778

How many sql are there?

733

tell me about various levels of constraint. : Sql dba

759

What is sql injection owasp?

727

How do I trace sql profiler?

707

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

751

What is acid property in a database?

763

How to Execute a Package in PL/SQL.?

807

What are the different types of database management systems?

724

What is the purpose of the primary key?

754