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

Can pl sql procedure have a return statement?

1005

What will you get by the cursor attribute sql%found?

953

What are the advantages of sql?

1042

what is normalization? : Sql dba

1071

How is data stored in sql?

1043

How do you add a column to a table?

1041

How are functions and procedures called in PL/SQL?

1197

Is crud a cuss word?

1016

Why do we create views in sql?

1132

Is sql port 1433 encrypted?

1013

Which is better join or inner query?

1021

What is database white box testing and black box testing?

1097

Is postgresql a server?

1034

What is db journal file?

1040

Where the sql database files are stored?

1002