SELECT sal FROM EMPLOYEES WHERE sal>(SELECT avg(sal) FROM EMPLOYEES);

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

Question Posted / gop

Answer Posted / gop

SELECT sal FROM EMPLOYEES WHERE sal>(SELECT avg(sal) FROM
EMPLOYEES);

Is This Answer Correct ?

47 Yes

6 No

Please Help Members By Posting Answers For Below Questions

what is the stuff function and how does it differ from the replace function? : Sql dba

1037

What are the set operators in sql?

1065

what is an alias command? : Sql dba

1094

How do you copy a table in sql?

1059

How do you write a complex sql query?

1052

What is the purpose of primary key?

1012

How can you save or place your msg in a table?

999

Is left join faster than join?

1045

Can we join two tables without common column?

998

What is a table partition?

1122

what is the command used to fetch first 5 characters of the string? : Sql dba

1633

Is subquery faster than join?

1009

What are the datatypes available in pl/sql ?

1095

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

971

What is a natural join sql?

963