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.
Answers were Sorted based on User's Feedback
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'
Is This Answer Correct ? | 18 Yes | 5 No |
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;
Is This Answer Correct ? | 14 Yes | 4 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
Is This Answer Correct ? | 1 Yes | 0 No |
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';
Is This Answer Correct ? | 2 Yes | 2 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
What are the commands used in sql?
What does select count (*) mean in sql?
How to revise and re-run the last sql command?
What is the difference between inner join and outer join?
How do I kill a query in postgresql?
How to know the last executed procedure?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the need of merge statement?
What is sql architecture?
wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure
How do I run a sql script?
What is insert command in sql?