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
13498 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

Mention what plvcmt and plvrb does in pl/sql?

1064

What is the purpose of primary key?

968

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3518

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1037

What are inner and outer joins examples of both?

883

What is rowtype?

956

What is restrict in sql?

1039

What is the usage of when clause in trigger?

992

Can we perform dml on view?

976

What is anonymous block in sql?

1077

Is sql low level language?

963

Can we insert data into view?

852

How to read xml file in oracle pl sql?

862

What is the difference between truncate and drop statements?

1086

What is not equal in sql?

1016