Select Name From Emp e inner join Dpt d on d.dptid=e.dptid Where sal>

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 / mai

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

Answer Posted / mai

Select Name
From Emp e inner join Dpt d
on d.dptid=e.dptid
Where sal>=2000 And sal<=3000
And dptname='x'

Is This Answer Correct ?

18 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is data manipulation language? : Sql dba

964

What is the difference between python and sql?

957

What are different types of triggers?

1056

Are there any features that are decommissioned in 11g that are not present in 11g?

2093

Is sql a programming?

947

Explain two easy sql optimizations.

979

Why trigger is used in sql?

937

explain mysql aggregate functions. : Sql dba

958

Is pl sql different from sql?

951

What is function and procedure?

999

Is primary key clustered index?

919

Can a foreign key be a duplicate?

880

What is database white box testing and black box testing?

1068

How many types of triggers are there in pl sql?

1035

What are sql*plus environment variables?

1056