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 are the different types of functions in sql?

1037

Is sql harder than python?

1076

Is it possible to create startup or shutdown trigger for on-schema?

1011

how to run 'mysql' commands from a batch file? : Sql dba

1094

What are the operators in sql?

1002

Is sql easier than java?

990

Why do we use procedures?

940

How do I view a table in sql?

993

What is form and report?

960

what is the use of double ampersand (&&) in sql queries?

1156

What are three advantages to using sql?

993

What is an exception in PL/SQL? What are the two types of exceptions?

1277

How to run sql commands in sql*plus?

1157

How do I install microsoft sql?

1029

What is dense_rank?

923