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

What is the command used to fetch the first 5 characters of a string?

1258

What is trigger in sql?

1156

How do I order columns in sql?

1073

what tools available for managing mysql server? : Sql dba

1132

What is the main reason behind using an index?

1059

Describe types of sql statements?

1105

what is online transaction processing (oltp)? : Sql dba

1040

write an sql query to find names of employee start with 'a'? : Sql dba

1089

Can we call a function containing dml statements in a select query?

1025

Is trigger a stored procedure?

984

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1226

What is a record in pl/sql?

1216

Differentiate pl/sql and sql?

1130

What are the basic techniques of indexing?

1112

Explain how to use transactions efficiently : transact sql

1017