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

List the various privileges that a user can grant to another user?

668

What is java sql package?

624

What is the difference between database trigger and stored procedure?

632

What are two statement types in sql?

635

What are dml commands?

631

explain mysql aggregate functions. : Sql dba

638

Why do we use triggers?

620

Which sorts rows in sql?

679

what are all the different types of indexes? : Sql dba

622

What is sql not null constraint?

682

Can we use having without group by in sql?

632

what are the 'mysql' command line arguments? : Sql dba

743

Why do we use view in sql?

627

Where can I learn sql for free?

603

Show code of a cursor for loop.

676