SELECT EMP_NO,EMP_SAL FROM EMP_TAB WHERE EMP_NO=&EMP

query to retrive the employees whose sal is greater than avg
sal

Question Posted / musthafa

Answer Posted / musthafa

SELECT EMP_NO,EMP_SAL
FROM EMP_TAB
WHERE EMP_NO=&EMP_NUM
GROUP BY EMP_NO
HAVING EMP_SAL > AVG(EMP_SAL)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I create a sql database?

1051

How do I run a query in pl sql developer?

1048

discuss about myisam index statistics collection. : Sql dba

1000

How do I view tables in sql developer?

1007

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3618

What are the sql commands?

1225

Explain the difference between 'between' & 'and' operators in sql

1040

How do you modify a table in sql?

1161

What is rownum and rowid?

1074

What is a heap in sql?

1137

Explain what is a database?

1131

What is latest version of sql?

1099

How do I view an execution plan in sql?

1032

How do you write a subquery?

1069

explain the delete statements in sql

1130