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
- 10817 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / patan
WE HAVE TABLE A (EID,ENAME,DEPT) AND TABLE B (NAMED,SID,DESIGNATION,SALARY)
--WE WANT TO RETRIEVE FOLLOWING
SELECT
B.NAMES AS NAMES
,B.DEPT AS DEPARTMENT
,B.SALARY AS SALARY
,B.DESIGNATION AS DESIGNATION
FROM TABLEA AS A
LEFT JOIN TABLEB AS B
ON A.EID=B.SID
ORDER BY B.NAMED
NOTE:WHEN WE ARE USING LEFT JOIN IT WILL MATCH THE RECORDS FROM BOTH THE TABLES AND LEFT TABLE OF RECORDS WILL DISPLAY...THAT ONLY I DID HERE
TRY IT..SURE IT WILL USEFUL
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between order by and group by?
Tell me can we use custom code in ssrs?
If a table does not have a unique index, can a cursor be opened on it?
What are three major types of constraints?
What is BLOCK statements in SQL?
What is a virtual table in sql?
What is the difference between count () and rowcount ()?
Explain can you implement data mining in ssrs?
Explain syntax for viewing, dropping and disabling triggers?
What are difference between Cluster index and Non-Cluster index?
Explain the properties of sub-query in sql server?
Explain SSRS Architecture?
Explain differences between web edition and business edition?
Can you always create a cache of a report?
What is the function of inner join?
