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 Histogram?

1506

What is a call statement? Explain with an example.

953

What is primary key and foreign key with example?

876

What is offset in sql query?

1073

How much does a sql dba make? : SQL DBA

891

How do I tune a sql query?

936

How do you update a table in sql?

929

What is t sql used for?

974

How do I find duplicates in the same column?

1000

what happens if null values are involved in expressions? : Sql dba

1001

What are the indexing methods?

1003

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1094

How exception handling is done in advance pl/sql?

920

Is progress software supports to ( pl/sql )?

973

What is compiled query?

956