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
- 14038 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
Can delete statement be rollbacked?
Can we use distinct and group by together?
Do we need to rebuild index after truncate?
What is the current version of postgresql?
how to escape special characters in sql statements? : Sql dba
How do I remove duplicates in two columns?
define sql insert statement ? : Sql dba
what are the advantages of sql ? : Sql dba
what are aggregate and scalar functions? : Sql dba
What is the best sql course?
what is dbms? : Sql dba
Does group by remove duplicates?
what is sql server agent? : Sql dba
Is primary key always clustered index?
what is collation? : Sql dba
