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 are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

739

How do you rank data in sql?

680

What is execution plan in sql?

762

What are the benefits of stored procedures?

709

What is delimiter sql?

704

Does sql between include endpoints?

748

What are the different type of joins in sql?

722

What is compiled query?

744

Is primary key clustered or nonclustered?

742

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

702

Can %notfound return null after a fetch?

756

What are triggers and its types?

755

What are the set operators in sql?

776

what is blob? : Sql dba

742

What is join view in sql?

698