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



suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dp..

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

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dp..

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

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dp..

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

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dp..

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

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dp..

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

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dp..

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

Is This Answer Correct ?    0 Yes 0 No

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dp..

Answer / ragunath

select name from Emp where Sal between 2000 and 3000

Is This Answer Correct ?    4 Yes 14 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between trigger and constraint?

3 Answers   HSBC,


What is the use of triggers?

0 Answers  


what is the syntax used for partition in tsql? : Transact sql

0 Answers  


What are different types of tables in sql?

0 Answers  


What is crud stand for?

0 Answers  






Is sql pronounced sequel or sql?

0 Answers  


how to find 5th row ?

10 Answers  


What is error ora-01000: maximum open cursors exceeded

0 Answers  


Can variables be used in sql statements?

0 Answers  


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.....

3 Answers  


What is TABLE SPACE?

4 Answers   ABB, TCS,


How do I partition a table in sql?

0 Answers  


Categories