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
- 13499 Views
- Geometric Software, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Which is better varchar or nvarchar?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
who introduced sql?
How to combine two stored procedures in sql?
what is “go” in t-sql? : Transact sql
How many types of tables are there?
Can we rename a column in the output of sql query?
What is a unique key?
What does rownum mean in sql?
Which is better join or subquery?
What is oracle and pl sql?
Which sorts rows in sql?
how to delete an existing column in a table? : Sql dba
What is procedure and function?
