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.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is 'mysqladmin' in mysql? : Sql dba

631


Explain some predefined exceptions.

678


What is informix sql?

613


Difference between truncate, delete and drop commands?

644


Can you skip header records while loading? : aql loader

623






how to enter numeric values as hex numbers? : Sql dba

658


What are the 3 modes of parameter?

793


How do sql databases work?

624


What is pl/sql language case sensitive?

730


What are the different parts of a package?

718


What is sql integrity?

658


what is a view? : Sql dba

715


What is pivot in sql?

590


Explain spool.

782


What are the different dcl commands in sql?

670