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
- 13983 Views
- Geometric Software, IBM, I also Faced
- E-Mail Answers
Answer Posted / ragunath
select name from Emp where Sal between 2000 and 3000
| Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
What does the sign mean in sql?
What is multiple partition?
How can a pl sql block be executed?
What is before and after trigger?
Write a sql select query that only returns each name only once from a table?
Name the operator which is used in the query for pattern matching?
Can a commit statement be executed as part of a trigger?
What is difference between hql and native sql?
Is ms sql traffic encrypted?
how would concatenate strings in mysql? : Sql dba
What is the difference between instead of trigger and after trigger?
What is clustered index sql?
Which is the correct statement about truncate and delete?
How many triggers can be applied on a table?
Why truncate is faster than delete?
