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
10374 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

Can you edit the .rdl code associated with a linked report?

149

How to achieve Paging of records in SQL SERVER?

1037

What do you understand by recursive stored procedure?

875

How to add additional conditions in SQL?

974

How to delete an existing database user?

970

How fixed length strings are truncated and padded?

942

What is the difference between deallocate cursor and close cursor?

1171

What is row-level compre?

944

List the different index configurations possible for a table?

884

What is the largest component inside a field?

1028

What are filegroups in sql server?

1014

How to retrieve error messages using odbc_errormsg()?

994

What are views in ms sql server?

1025

What is de-normalization and what are some of the examples of it?

927

What are the security related catalog views? : sql server security

914