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
13767 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 can we destroy the cookie? : Sql dba

1011

What mean sql?

1009

How do I use google cloud in sql?

1087

How do you write a complex sql query?

1077

What is pl/sql table? Why is it used?

1043

What is rowtype?

1019

Is sql similar to python?

973

What is cte?

982

What is data profiling in sql?

1077

Can we use distinct and group by together?

1057

What is the difference between sql and mysql?

1117

Does sql backup shrink transaction log?

979

What is difference between function and trigger?

1048

Which version of sql do I have?

1056

What is a string data type in sql?

1042