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
- 10797 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
How many columns can we include on clustered index ?
How to loop through the result set with @@fetch_status?
List the ways in which dynamic sql can be executed?
Explain transaction server isolation?
Why we should not use triggers?
What is the impact on other user sessions when creating indexes?
Explain about Normalization?
Explain the steps to use transact-sql cursor?
Explain what stored procedure sp_replcounters is used for? : sql server replication
How to use "begin ... End" statement structures in ms sql server?
What are sub reports and how to create them?
What command is used to create a database in the sql server and how?
What is model database? : SQL Server Architecture
What are the two authentication modes in sql server?
How to see the event list of an existing trigger using sys.trigger_events?
