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
what is 'mysqladmin' in mysql? : Sql dba
Explain some predefined exceptions.
What is informix sql?
Difference between truncate, delete and drop commands?
Can you skip header records while loading? : aql loader
how to enter numeric values as hex numbers? : Sql dba
What are the 3 modes of parameter?
How do sql databases work?
What is pl/sql language case sensitive?
What are the different parts of a package?
What is sql integrity?
what is a view? : Sql dba
What is pivot in sql?
Explain spool.
What are the different dcl commands in sql?