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
- 11639 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 are sql*plus environment variables?
Are views faster than queries?
What is raid? How does it help storage of databases?
What is the reports view in oracle sql developer?
What is trigger explain with example?
What is audit logout in sql profiler?
What does partition by mean in sql?
What is the primary use of normalization?
What is embedded sql with example?
Are stored procedures compiled?
explain access control lists. : Sql dba
what is meant by urlencode and urldocode? : Sql dba
what are dynamic queries in t-sql? : Transact sql
Compare sql & pl/sql
does sql support programming? : Sql dba
