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 rdbms? : Sql dba

1008

What is trigger in sql? Explain

981

What is a rank in sql?

952

What is the use of nvl function?

1180

What is asqueryable?

960

What is the difference between function, procedure and package in pl/sql?

1240

What is the use of & in pl sql?

1038

Explain the methods used to protect source code of pl/sql.

1012

What is cross join sql?

911

Why stored procedure is faster than query?

1047

Explain what is a database?

1079

What is form and report?

969

what is a database lock ? : Sql dba

1158

What do you think about pl/sql?

1016

How to move files from one directory to another in pl sql?

1182