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
- 12115 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
How many scalar data types are supported in pl/sql?
What is cold data?
Why function is used in sql?
Why do we need view in sql?
Define commit, rollback and savepoint?
Should I use mbr or gpt?
Explain the uses of control file.
What is java sql package?
what is data manipulation language? : Sql dba
What is raid? How does it help storage of databases?
Is it possible to read/write files to-and-from PL/SQL?
Can we join tables without foreign key?
How do I trace sql profiler?
What is denormalization in a database?
What is meant by <> in sql?
