Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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.

Question Posted / nitin.amrutkar

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

How do I run a sql script?

0 Answers  

how do you know the version of your mysql server? : Sql dba

0 Answers  

How many commands are in sql?

0 Answers  

Explain the components of sql?

0 Answers  

what is heap table? : Sql dba

0 Answers  




i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

What are the sql aggregate functions?

0 Answers  

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

Can we insert data in view?

0 Answers  

Describe different types of general function used in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories