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

Is progress software supports to ( pl/sql )?

973

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

958

What are records give examples?

954

How do you determine the current isolation level? : Transact sql

1075

Explain the significance of the & and && operators in pl sql.

952

Can we alter stored procedure?

945

Are null values same as that of zero or a blank space?

969

Can we insert delete data in view?

900

How to load data with sql*loader?

1001

What is the difference between sql and isql*plus?

1008

what is recursive stored procedure? : Sql dba

932

explain the options of myisamchk to improve the performance of a table. : Sql dba

954

What is record data type?

861

Can you do multiple joins in sql?

977

Is there a way to automate sql execution from the command-line, batch job or shell script?

919