SELECT Sal FROM Emp WHERE Sal

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

Question Posted / swastik

Answer Posted / swastik

SELECT Sal
FROM Emp
WHERE Sal >
(
SELECT AVG(Sal)
FROM Emp
);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which is faster union or join?

972

what happens if you no create privilege in a database? : Sql dba

1002

Why are aggregate functions called so?

951

What is sequence in sql?

1027

What is difference between sql and excel?

1098

Can we write dml inside a function in sql server?

957

Which command is used to delete a package?

1178

Does sql profiler affect performance?

998

Is nosql relational?

947

What is meant by <> in sql?

981

What is denormalization in a database?

1058

How does left join work in sql?

1006

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

961

Explain the update statement in sql

995

Define commit, rollback and savepoint?

1033