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 is cursor in pl sql?

1097

what is a trigger? : Sql dba

1012

Is primary key always clustered index?

993

what is “go” in t-sql? : Transact sql

1088

What are tables and fields in the database?

1093

How do you truncate?

892

What is trigger with example?

1066

What are the different dml commands in sql?

1150

how can we find the number of rows in a table using mysql? : Sql dba

1069

What is schema in sql example?

1159

What is not in sql?

935

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

980

Can a trigger call a stored procedure?

1052

How can use stored procedures in sql?

1116

What is sqlerrd?

956