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
- 12116 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
What is sql and also describe types of sql statements?
What is the least restrictive isolation level? : Transact sql
How to select random rows from a table?
Which sorts rows in sql?
Why are cursors used?
How can you know that statistics should be updated?
What is offset and limit in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is native sql query?
Is join an inner join?
Why procedure is used in sql?
what is a table in a database ? : Sql dba
What is the difference between nested table and varray?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is the sql*loader? : aql loader
