by using unions we can do it create two tables separetly and apply union i

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.

Question Posted / varunkumar

6 Answers
10360 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

Please Help Members By Posting Answers For Below Questions

Explain the microsoft sql server delete command? : SQL Server Architecture

1004

What are the restraints imposed on the table design by a merge replication?

981

What is a rollup clause?

905

What is de-normalization in sql database administration? Give examples?

926

What is sql server query analyzer?

961

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

956

What are drillthrough reports?

141

Why do we partition data?

973

what is the difference between count(*) and count(1) ?

1024

What is the filtered index?

972

Explain foreign key in sql server?

973

Define tool Manage Statistics in SQL Server 2000 query ?

1021

Indexes are updated automatically is the full-text index also updated automatically?

974

What is analysis service repository?

968

How do I shrink an ldf file?

931