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

does sql support programming? : Sql dba

1088

how to rename an existing column in a table? : Sql dba

1082

Is mariadb a nosql database?

1099

What are the possible values that can be stored in a boolean data field?

1042

What are different types of sql?

1264

How can I tell if sql is running?

1133

What is the maximum rows in csv?

977

What is the least restrictive isolation level? : Transact sql

1106

What is difference between table and view?

1137

how to get a list of all tables in a database? : Sql dba

1030

What are the qualities of 2nf?

1096

What is synonyms?

1118

What are expressions?

1062

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1248

what are the t string functions available in tsql? : Transact sql

1064