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
- 10542 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
How can I track the changes or identify the latest insert-update-delete from a table?
What are rest-style architecture's?
What is built-in function?
Define candidate key, alternate key, and composite key.
Explain what are various ways to enhance the ssrs report?
What is ms sql server reporting services?
What happens if the update subquery returns no rows in ms sql server?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How many triggers you can have on a table?
What are the results of running this script?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is the contrast amongst drop and truncate?
What are the new features are introduced in sql server 2012 reporting services?
Can a database be shrunk to 0 bytes, if not, why?
When does a workload on SQL Azure get throttled?
