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.
Answer Posted / jayesh sonawane
this one correct try it:
SELECT
distinct
B.NAMES AS NAMES
B.SID
,B.DEPT AS DEPARTMENT
,B.SALARY AS SALARY
,B.DESIGNATION AS DESIGNATION
FROM TABLEB AS A join TABLEB AS b
on A.EID=B.SID and B.DEPT=A.DEPT and B.SALARY=A.SALARY and B.DESIGNATION =A.DESIGNATION
join TABLEA as taba on ON A.taba =B.SID
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
which backup strategy you are following at ur company
What functions can a view be used to performed?
Describe in brief authentication modes in sql server.
what is a correlated sub-query? : Sql server database administration
What is the use of custom fields in report?
How can sql server instances be hidden? : sql server security
What is table value parameters (tvp)?
How many null values we can have in a unique key field in sql server?
How to configure odbc dsn with different port numbers?
What is resource governor in sql server?
Explain trigger classes i.e. Instead of and after trigger?
List out what other servers you can use with ssrs?
What is an index in sql?
What is msdb database? : SQL Server Architecture
How to retrieve field values using mssql_result()?