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
- 14034 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
define sql insert statement ? : Sql dba
How do I remove duplicates in two columns?
What is the current version of postgresql?
what is dbms? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
Does group by remove duplicates?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Can we use distinct and group by together?
what are all the common sql function? : Sql dba
what are aggregate and scalar functions? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Do we need to rebuild index after truncate?
What is the best sql course?
Is primary key clustered index?
Can we rollback truncate?
