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
- 14040 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
what is bcp? When does it used? : Sql dba
Is primary key clustered index?
Do we need to rebuild index after truncate?
Is inner join faster than left join?
What is the current version of sql?
Can delete statement be rollbacked?
how to use regular expression in pattern match conditions? : Sql dba
What is the best sql course?
how to start mysql server? : Sql dba
What is the current version of postgresql?
how many tables will create when we create table, what are they? : Sql dba
what are aggregate and scalar functions? : Sql dba
Does group by remove duplicates?
How do I remove duplicates in two columns?
What is your daily office routine?
