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
- 9119 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 page in sql server?
Why use stored procedures in sql server?
When is the use of update_statistics command?
what is a join? : Sql server database administration
Will the writetext statement activate a trigger?
What are the types of user defined functions in sql server?
Does sql server 2000 clustering support load balancing?
Explain an automatic checkpoint
What stored by the master?
Tell me when is the update_statistics command used?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is it unwise to create wide clustered index keys?
What are window functions in sql server?
What do you understand by integration services in sql server?
What are the extra roles available in msdb? : sql server security
