select salary from eno where salary<(select avg(salary) from eno ) an

i have a table
eno dno sal
1 10 200
2 10 150
3 10 100
4 20 75
5 20 100

i want to get sal which is less than the avg sal of thri dept.

eno dno sal
2 10 150
3 10 100
4 20 75

Question Posted / parth

12 Answers
19943 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / parth

select salary from eno where salary<(select avg(salary)
from eno ) and rownum < 6

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

define join and explain different type of joins? : Sql dba

954

What is the use of <> sql?

980

How much does a sql dba make? : SQL DBA

945

What is difference between nchar and nvarchar?

1026

what is a table in a database ? : Sql dba

1040

What is the difference between sql and mysql?

1117

Does access use sql?

1040

what is myisam? : Sql dba

1084

What are the key differences between SQL and PL SQL?

1211

What makes a good primary key?

1040

what is union? : Sql dba

1027

explain the difference between bool, tinyint and bit. : Sql dba

999

What are the advantages of sql? Explain

1106

What is pl/sql language case sensitive?

1125

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

1010