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 is the difference between trigger and constraint?
What is the use of triggers?
what is the syntax used for partition in tsql? : Transact sql
What are different types of tables in sql?
What is crud stand for?
Is sql pronounced sequel or sql?
how to find 5th row ?
What is error ora-01000: maximum open cursors exceeded
Can variables be used in sql statements?
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
What is TABLE SPACE?
How do I partition a table in sql?