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 auto increment?

934

when is the use of update_statistics command? : Sql dba

966

What is pl sql quora?

1069

What are operators available in sql?

977

What is interval partition?

980

Are dml statements autocommit?

980

Can one improve the performance of sql*loader? : aql loader

980

What is column?

935

what is query cache in mysql? : Sql dba

990

List and explain the different types of join clauses supported in ansi-standard sql?

1299

What is anonymous block in sql?

1070

What are the types of join in sql?

1026

Is ms sql is free?

948

what is sub-query? : Transact sql

1038

Why we use pl sql?

903