Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 7 Answers
- 13595 Views
- Geometric Software, IBM, I also Faced
- E-Mail Answers
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 are pl/sql packages?
how many ways we can we find the current date using mysql? : Sql dba
Can we call a function containing dml statements in a select query?
How do I count records in sql?
How do you declare a constant?
What is sqlite format?
What is varchar sql?
How to get list of all tables from a database?
What are sql functions? Describe in brief different types of sql functions?
What is a field in a database?
Is sql database free?
Do stored procedures prevent sql injection?
how to calculate the difference between two dates? : Sql dba
The select into statement is most often used to create backup copies of tables or for archiving records?
how to escape special characters in sql statements? : Sql dba
