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

Name the operator which is used in the query for pattern matching?

912

how to create a new table by selecting rows from another table in mysql? : Sql dba

1033

What is the difference between clustered and non-clustered indexes?

1045

how do you know if your mysql server is alive? : Sql dba

1046

what are the join types in tsql? : Transact sql

1018

What is loop in pl sql?

999

What is sql basics?

1008

What are stuff and replace function?

1031

What does bitemporal mean?

1025

I need a function for a train ticket reservation please answer it thanks in advance

978

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3023

What is the main difference between sql and pl/sql?

1048

What are stored procedures used for?

975

What is sqlerrm?

893

Mention what is the plv (pl/vision) package offers?

1074