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
- 13673 Views
- Geometric Software, IBM, I also Faced
- E-Mail Answers
Answer Posted / mai
Select Name
From Emp e inner join Dpt d
on d.dptid=e.dptid
Where sal>=2000 And sal<=3000
And dptname='x'
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What is integrity in sql?
What are predefined functions in sql?
how do you know the version of your mysql server? : Sql dba
What is the difference between function, procedure and package in pl/sql?
What is a ddl command?
what are the types of subquery? : Sql dba
How to take user input in pl sql?
What is the usage of distinct keyword?
What is normalization in a database?
What is clause in sql?
what is top in tsql? : Transact sql
What is data control language (dcl)?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How are functions and procedures called in PL/SQL?
Can we insert delete data in view?
