Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 10617 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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
What are the different types of collation sensitivity?
What are the advantages of paper records?
Explain different forms of normalization?
How to update muliple row in single query?
What is normalization? Explain different forms of normalization?
Explain aggregate functions?
Mention the differences between having and where clause.
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What are the purposes and advantages stored procedure?
Can you explain powershell included in sql server 2008?
How to find the list of fixed hard drive and free space on server?
What is difference between Datepart() and Datename() in SqlServer?
Explain powershell included in sql server 2008?
What are the security related catalog views? : sql server security
How to convert character strings into numeric values?
