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
- 13772 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 the difference between alter trigger and drop trigger statements?
what is a record in a database ? : Sql dba
what are the different index configurations a table can have? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is asqueryable?
Is trigger a stored procedure?
How to disable a trigger name update_salary?
Explain the purpose of %type and %rowtype data types with the example?
How do I install sql?
What is sql rowcount?
What is the non-clustered index in sql?
Can we create clustered index without primary key?
How is data stored on a disk?
What is pls_integer in pl sql?
