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
- 11569 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 are the three pl sql block types?
Define tables and fields in a database
how can you see all indexes defined for a table? : Sql dba
What is the difference between clustered and non-clustered index in sql?
What does count (*) mean in sql?
What are few of the schema objects that are created using PL/SQL?
How do you know if a relationship is 2nf?
what is the difference between primary key and unique key? : Sql dba
How many types of normalization are there?
Define select, insert, create, delete, update, drop keywords
What are the string functions in sql?
What is the usage of distinct keyword?
How do I know if I have sql express or standard?
What is the maximum database size for sql express?
What is t-sql? : Transact sql
