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
- 10607 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / shankaranarayanan v
select eid,ename,dept,desg,salary from a,b
where a.eid=b.sid
(when a.eid=b.sid)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to get all stored procedures in sql server?
Explain what is the difference between union and union all?
List some major differences between triggers and stored procedures?
What is 1nf 2nf?
Write a program to fetch first 10 records from a file?
how can u get last observation in an unknown dataset ?
What is statement level trigger?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How do you create an execution plan?
Define union, union all, minus, intersect?
What are cascading parameters in ssrs reports?
Explain candidate key, alternate key, and composite key?
Explain primary key, foreign key and unique key?
Can you always create a cache of a report?
Why are you getting errors when creating a new odbc dsn?
