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
- 8662 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 to skip remaining statements in a loop block using continue statements?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is the full form of ddl?
What is the difference between a "where" clause and a "having" clause?
How to connect Azure federated root database and apply federation in entity framework?
Which tcl commands are available on the sql server?
What is multilevel indexing?
How to end a stored procedure properly in ms sql server?
Explain error handling in ssis?
Show Practically Sql Server Views are updatable?
How to search for a string in all stored procedure in sql server?
Do you know sql server 2008 introduces automatic auditing?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How is foreign key related to primary key?
Is oracle faster than sql server?
