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
- 13587 Views
- Geometric Software, IBM, I also Faced
- E-Mail Answers
Answer Posted / abhishekjaiswal
select e.department_id,e.last_name,e.salary,d.department_name from employees e,
departments d
where e.department_id=d.department_id and
e.salary between 2000 and 10000
and lower(d.department_name)='finance'
/
Out put
DEPARTMENT_ID LAST_NAME SALARY DEPARTMENT_NAME
------------- ------------------------- ---------- --------------------
100 Faviet 9000 Finance
100 Chen 8200 Finance
100 Sciarra 7700 Finance
100 Urman 7800 Finance
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does sql backup shrink transaction log?
What is dynamic query?
What is the main reason behind using an index?
how do you tune the slow running queries in oracle db , explain the methodology
Can we rollback after truncate?
What is sql query limit?
Why is theta join required?
What is the difference between microsoft sql and mysql?
Does view store data in sql?
Can there be more than one function with a similar name in a pl/sql block?
What is difference between sql function and stored procedure?
define sql update statement ? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
How do you update a table in sql?
What is a parameter query?
