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

What is integrity in sql?

1109

what is the stuff function and how does it differ from the replace function? : Sql dba

1111

Is join an inner join?

1026

Is left join same as inner join?

1219

Does truncate release storage space?

1141

What is normalisation and its types?

1046

Inline the values in PL/SQL, what does it mean.?

1275

What are the types of records?

1040

where are cookies actually stored on the hard disk? : Sql dba

1081

What is your daily office routine?

2320

Where not exists in sql?

1034

What is a full join?

1048

What is compilation error in pl sql?

1025

How does sql*loader handles newline characters in a record? : aql loader

1095

What are the 3 types of behavioral triggers?

1319