Answer / mai

Select Name
From Emp e inner join Dpt d
on d.dptid=e.dptid
Where sal>=2000 And sal<=3000
And dptname='x'

Answer / selvaraj v , anna university

SELECT * FROM EMP E,DEPTS D WHERE E.DEPT_ID=D.DEPT_ID AND
E.SALARY BETWEEN 2000 AND 3000 ORDER BY EMP_NO;

Answer / manasa

SELECT e.name,d.dept from employee e INNERJOIN dept d ON e.deptid=d.deptid WHERE e.salary between 2000 AND 3000

Answer / om patel

SELECT E.ENAME FROM EMP E ,DEPT D WHERE E.DEPTNO=D.DEPTNO
AND SAL BETWEEN 2000 AND 3000 AND D.DNAME='X';

Answer / sravan

You can also solve it by using sub-query

SELECT DISTINCT NAME FROM EMP E
WHERE SAL>2000 AND SAL<3000
AND E.DEPTID IN (SELECT D.DEPTID FROM DPT D
WHERE DEPTNAME='X');

thanks

Answer / 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

Answer / ragunath

select name from Emp where Sal between 2000 and 3000

what are the different tables present in mysql? : Sql dba

1 Answers  

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

What is the usage of distinct keyword?

1 Answers  

Explain the the update statement in sql?

1 Answers  

how to create a database in oracle?

3 Answers  

How does an execution block start and end in pl sql?

1 Answers  

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,

What do you understand by pl/sql cursors?

1 Answers  

Write a query to find second highest salary of an employee.

27 Answers  

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

Can delete statement be rollbacked?

0 Answers  

Write a unique difference between a function and a stored procedure.

1 Answers