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
- 13490 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 is a scheduled jobs or what is a scheduled tasks? : Sql dba
Is a foreign key always unique?
What is the difference between left and left outer join?
What is sql not null constraint?
How do I debug a stored procedure?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is null in pl/sql?
What are the limitations of sql express?
Is sql port 1433 encrypted?
What is a memo field?
What is break?
how can we repair a mysql table? : Sql dba
Is time a data type in sql?
What is the non-clustered index in sql?
How to combine two stored procedures in sql?
