Their are two tables 'A' and'B'.Table 'A' contains 3 columns
named 'eid','ename','dept'.
Table 'B'contains 3 columns
named'sid','designation','salary'.
We have to retrieve the names of employees working in the
same department,same designation and same salary.
Its urgent can anyone help me out in this problem.
- 6 Answers
- 8660 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / varunkumar
by using unions we can do it create two tables separetly and
apply union in between two tables .
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Define compound operators?
What is repeatable read?
How many levels of sp nesting is possible?
What are the database roles? : sql server security
What is the user of Primary key?
Can sql server be linked with other servers like oracle?
What is the architecture of ms sql reporting service?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Do you know what are various aggregate functions that are available?
What do I need to start working with sql studio? : sql server management studio
Explain user defined functions?
What is the difference between grant and with grant while giving permissions to the user?
How would you choose between a clustered and a non-clustered index?
How to disable triggers using "disable trigger"?
