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
- 11574 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
How do I count rows in sql?
What is sql in java?
Who is the owner of mysql database?
Is mariadb a nosql database?
What is trigger in pl sql with examples?
what is 'mysqld'? : Sql dba
What is mutating trigger?
explain advantages of myisam over innodb? : Sql dba
What is sequence in sql?
What are all the different normalization?
What is the difference between rename and alias?
what is data manipulation language? : Sql dba
What does bitemporal mean?
what are the advantages of using stored procedures? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
