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

how does a local variable is defined using t-sql? : Transact sql

987

What are local and global variables and their differences?

1078

Is hadoop a nosql?

987

Why do we use subquery?

993

What normalization means?

953

What is multiple partition?

953

What is faster join or subquery?

1001

what is the use of set statement in tsql? : Transact sql

995

Write a sql query to find the names of employees that begin with ‘a’?

992

Could you please provide oca (oracle 10g) dumps for my certification ?

5131

What are the built in functions of sql?

1017

What are transaction and its controls?

1026

What is multiple columns?

1049

What is pragma in pl sql?

1089

What is parallel hint?

1304