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

Can sql function call stored procedure?

1032

What does closing a cursor do?

1330

What is mdf ldf and ndf?

1007

Why truncate is used in sql?

1013

Is left join faster than inner join?

1134

What is difference between sql function and stored procedure?

1015

how to check server status with 'mysqladmin'? : Sql dba

1086

What is composite data type in pl sql?

1123

how many groups of data types? : Sql dba

1034

Can we use ddl commands in pl sql?

1171

Why is sql*loader direct path so fast?

1112

What sql does db2 use?

987

How do sql databases work?

1006

How you improve the performance of sql*loader? : aql loader

1020

Can pl sql procedure have a return statement?

1036