select salary,AVG_SALARY from z1 where salary>AVG

query to retrive the employees whose sal is greater than avg
sal

Question Posted / gourav

Answer Posted / gourav

select salary,AVG_SALARY from z1
where salary>AVG_SALARY

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is a cursor? : Sql dba

1018

What is cte?

969

what is self join and what is the requirement of self join? : Sql dba

1136

What are the types of join and explain each?

1029

What is dml and ddl?

946

Is sql a backend language?

1086

What is trigger explain it?

1006

Explain the working of primary key?

1087

explain mysql aggregate functions. : Sql dba

980

What are the topics in pl sql?

967

What are some predefined exceptions in pl/sql?

1157

Is null operator in sql?

1021

What is mdf ldf and ndf?

990

How do I view output in sql developer?

1072

What is user defined functions?

961