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
- 11570 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
Can we write ddl statements in functions?
what is isam? : Sql dba
How many types of index are there?
What are triggers and its types?
explain the difference between bool, tinyint and bit. : Sql dba
What is the difference between drop and truncate commands?
Write an sql query to select all records from the table?
What is sql partition?
What is a database event trigger?
What does pragma mean?
What type of database is sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Is json a nosql?
Are there any features that are decommissioned in 11g that are not present in 11g?
Does execute immediate commit?
