select eid,ename,dept,desg,salary from a,b where a.eid=b.sid (when

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 / shankaranarayanan v

6 Answers
10809 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / shankaranarayanan v

select eid,ename,dept,desg,salary from a,b
where a.eid=b.sid

(when a.eid=b.sid)

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain time data type in sal server 2008?

973

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1102

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

1073

What is meant by dirty read?

1047

Explain about integration services of Microsoft SQL server?

1093

Explain difference between control flow and data flow?

1023

What is difference between inner join and join?

1096

Difference between DELETE and TRUNCATE?

1102

When would you use sql joins?

1032

what is bit datatype? : Sql server database administration

965

What is index in an assignment?

998

Explain what is analysis service repository?

1051

What is wrong with sql server client libarary dll, ntwdblib.dll?

1097

How much is a sql server license?

1012

What is full outer join in sql server joins?

1143