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 cte sql?

994

How do I write a sql query in pgadmin 4?

983

How do you use join?

941

What is the basic structure of an sql?

1098

What is lexical units in pl sql?

1146

What is pl sql script?

1031

What is offset and limit in sql?

1058

Define the select into statement.

1056

what is view? : Sql dba

959

Define select, insert, create, delete, update, drop keywords

1048

What is set serveroutput on in pl sql?

1296

What is data type in database?

992

How many databases can sql express handle?

984

What sql does db2 use?

980

What are the ways on commenting in a pl/sql code?

1134