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 is a PL/SQL code compiled?

1181

How do you use join?

907

Explain ttitle and btitle.

1079

how to escape special characters in sql statements? : Sql dba

995

What is percent sign in sql?

1236

what is online transaction processing (oltp)? : Sql dba

955

what is the use of friend function? : Sql dba

994

What is coalesce in sql?

1001

What are sql data types?

973

What is trigger in pl sql with examples?

1000

Why do we use set serveroutput on?

944

what is data control language? : Sql dba

980

Does access use sql?

990

What is the clause we need to add in function body to return variable?

987

How do I order columns in sql?

931