Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13973 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
Why we use triggers in mysql?
Which join condition can be specified using on clause?
How to Declare Fixed Length String Value In PL SQL
What is sql procedures and functions?
What is procedure function?
What is vector point function?
how to enter binary numbers in sql statements? : Sql dba
How do I filter in sql profiler?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
Why trigger is used in sql?
what are the differences between char and varchar? : Sql dba
What is the best free sql database?
How many joins in sql?
What is where clause in sql?
What is t-sql? : Transact sql
