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
- 13981 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 command used to fetch first 5 characters of the string? : Sql dba
What is mutating sql table?
Why we use join in sql?
Is mariadb nosql?
Where the sql database files are stored?
What is cursor explain with example?
Which query operators in sql is used for pattern matching?
what is sql server agent? : Sql dba
What is difference between sql and oracle?
What is sql deadlock?
List the ways to get the count of records in a table?
What is assignment operator in pl sql?
What are the disadvantages of file system?
What can I use instead of union in sql?
How does a covering index work?
