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
- 13491 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 the difference between cluster and non cluster index? : Sql dba
What is t sql in sql server?
What is a left join?
What is sharding in sql?
How to run sql functions in pl/sql?
What are different types of sql commands?
How delete a row in sql?
what is oracle database ? : Sql dba
What is the mutating table and constraining table?
What are the ddl commands?
How sql query is executed?
Is primary key clustered index?
What are basic techniques of indexing?
What are variables in pl sql?
difference between anonymous blocks and sub-programs.
