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

How to configure and test odbc dsn settings?

1120

Explain what are the database objects? : SQL Server Architecture

1038

What is open database communication (odbc)?

1024

What do you do in data exploration

949

Explain candidate key, alternate key, and composite key?

964

How to drop an existing schema in ms sql server?

1055

What is the difference between clustered index and primary key?

885

What is the latest version of microsoft sql server?

1006

Explain how does the report manager work in ssrs?

925

What are sql server procedures?

951

Explain differentiate between a having clause and a where clause?

866

Write a sql query to sort on different column name according to the parameters passed in the function?

868

What is tempdb in sql server?

941

What are different types of table joins?

978

How to delete existing rows in a table?

1114