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 can we make an if statement within a select statement?

1068

What is procedure in pl sql?

1090

What is the difference between an inner join and an outer join?

1082

what is the difference between a local and a global temporary table? : Sql dba

1128

What is the purpose of using pl/sql?

1189

what is 'mysqladmin' in mysql? : Sql dba

1074

How do I run a pl sql procedure in sql developer?

1022

How many sql statements are used? Define them.

1081

Is sql better than access?

1069

What is full join in sql?

1035

Is sqlite free?

1024

What are the different tcl commands in sql?

1230

How do I run sql?

1254

What does the acronym acid stand for in database management?

1089

What is sqlcontext?

1147