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
- 8690 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 are the properties of sub-query?
How does index makes search faster?
How you trouble shoot when any job fails
Differentiate between a primary key and a unique key.
What do you understand by triggers and mention the different types of it?
Explain difference between control flow and data flow?
What is a not null constraint?
What are the mathematical functions supported by sql server 2005?
What is query optimizer in sql server?
What are constraints in microsoft sql server?
How to join two tables in a single query in ms sql server?
Define compound operators?
What is the difference between a unique key and primary key?
Mention the different types of triggers?
What do you understand by recursive stored procedures?
