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
- 11637 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 different tcl commands in sql?
How many functions are there in sql?
What is meant by <> in sql?
Where the sql database files are stored?
Can we use ddl statements in stored procedure?
What is duration in sql profiler trace?
Does sql full backup truncate logs?
What is sql key?
What are the different types of functions in sql?
Is pl sql and postgresql same?
What are all the different normalization?
What is query optimization in sql?
What are different types of triggers?
Why indexing is needed?
How do you go back in sql?
