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
- 9572 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
What’s the use of custom fields in report?
What is the difference between for auto and for nested?
Define primary key?
What is a bit datatype?
Explain about thread and memory management process of SQL?
Does an index slow down updates on indexed columns?
What is an identity?
How to delete duplicate rows?
What kind of problems occurs if we do not implement proper locking strategy?
What happens if ntwdblib.dll is missing on your machine?
What is a user-defined function in the sql server and what is its advantage?
Where is localdb stored?
How to restore performance issues and how to check?
What are the three different part of rdl file explain them?
What are the dis_advantages of stored procedures, triggers, indexes?
