SELECT e.name,d.dept from employee e INNERJOIN dept d ON e.deptid=d.deptid

suppose I have two table one Emp and other is dpt.
Emp table has a field ,dept id,name ,sal and dpt table has a
field dept id,dept name.
Now I want to find out the emplyee list whose sal is between
2000-3000 from dept x.

Question Posted / manasa

7 Answers
13683 Views
Geometric Software, IBM, I also Faced
E-Mail Answers

Answer Posted / manasa

SELECT e.name,d.dept from employee e INNERJOIN dept d ON e.deptid=d.deptid WHERE e.salary between 2000 AND 3000

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I view a sql database?

1007

Is sql the best database?

956

Why do you partition data?

1009

What does over partition by mean in sql?

958

what is the difference between a having clause and a where clause? : Sql dba

1062

Is left join inner or outer by default?

1006

What is a stored procedure in sql with example?

1105

What are field types?

978

What are the types pl/sql code blocks?

1109

What is a primary key example?

942

What are the two types of exceptions.

1144

how to get a list of all tables in a database? : Sql dba

954

What is coalesce sql?

977

What is pl sql in oracle?

1024

Can sql function call stored procedure?

993