select salary from table_name where salary >=(select avg(salary) from ta

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

Question Posted / damy

Answer Posted / damy

select salary from table_name where salary >=(select avg(salary) from table_name)

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the types of variable use in pl sql?

1087

What is java sql package?

1099

How show all rows in sql?

1017

What is informix sql?

985

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

1011

Explain the working of foreign key?

1071

What are sql injection vulnerabilities?

989

What does <> sql mean?

1093

What is the difference between nested table and varray?

1013

What is rename command in sql?

1039

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

How does postgresql compare to mysql?

1039

What is indexes?

1063

what happens if null values are involved in expressions? : Sql dba

1046

What are the types of views in sql?

1104