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

What is difference between table and view?

1142

What type of database is cloud sql?

1160

Which is faster view or stored procedure?

1012

What is the use of index in hive?

1057

How to order siblings in oracle hierarchy queries?

1120

What is user defined functions?

1031

What is cursor and its types?

1157

What is foreign key in sql with example?

981

What are predefined functions in sql?

1109

What are the types of dbms?

1029

What is raw datatype in sql?

1111

Define tables and fields in a database

1182

What does stand for in sql?

1026

What are the various levels of constraints?

1172

What is rownum and rowid?

1079