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
- 13560 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 compiled query?
What is before trigger?
Does truncate free space?
Why are sql stored procedures used?
What is a natural join sql?
Explain the commit statement.
Can procedure in package be overloaded?
Can we join same table in sql?
Can we create a trigger on view?
how to drop an existing index in mysql? : Sql dba
What is the maximum number of triggers, you can apply on a single table?
What are stuff and replace function?
How can you load microsoft excel data into oracle? : aql loader
Determine if oracle date is on a weekend?
difference between anonymous blocks and sub-programs.
