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
- 13676 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
Is sqlexception checked or unchecked?
How to run pl/sql statements in sql*plus?
What is the difference between sql and isql*plus?
What are the events on which a database trigger can be based?
What is the difference between delete and truncate commands?
Why do we use view in sql?
What is the benefit of foreign key?
Define SQL and state the differences between SQL and other conventional programming Languages?
Which nosql database is best?
What are the parts of a basic sql query?
What is the difference between a primary key and a clustered index?
Explain ddl statements in pl/sql?
what is a composite key ? : Sql dba
Is sql low level language?
Is sql the best database?
