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
- 13771 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
Can we enter data in a table in design view?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
what is row? : Sql dba
what are local and global variables and their differences? : Sql dba
How do I view a sql trace file?
What are the different type of joins in sql?
What is procedure explain with example?
How would you convert date into julian date format?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
When are we going to use truncate and delete?
what is user defined functions? : Sql dba
Is primary key clustered index?
What is difference between sql function and stored procedure?
What is a recursive join sql?
What is dense_rank?
