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

How do I kill a query in postgresql?

1015

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1006

What is nosql example?

971

Can I learn sql in a week?

1008

What is the syntax to add a record to a table?

1023

What is the source code of a program?

1005

How to add a column ‘salary’ to a table employee_details?

955

What is pl sql architecture?

924

What is pl sql script?

979

What is Collation Sensitivity ? What are the various type ?

906

What is sql character function?

996

Is sql port 1433 encrypted?

974

What is a full join sql?

983

how many values can the set function of mysql take? : Sql dba

935

How do I make my sql query run faster?

893