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.
- 7 Answers
- 11655 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
how to add a new column to an existing table in mysql? : Sql dba
Explain what is sql*plus?
Why is sql better than hql?
What is character functions?
define data blocks ? : Sql dba
What is column?
What is sql trigger example?
what are the differences among rownum, rank and dense_rank? : Sql dba
Can a select statement fire a trigger?
Is delete faster than truncate?
how to include character strings in sql statements? : Sql dba
what is union, minus and interact commands? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
what is isam? : Sql dba
Where is sql database stored?
