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
- 8661 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
What is view in sql?
How to list all triggers in the database with sys.triggers in ms sql server?
Can we add our custom code in ssis?
How to connect sql server management studio express to sql server 2005 express?
How do I create a stored procedure in sql server?
Explain few of the new features of sql server 2008 management studio
Explain the stored procedure?
How does recursive cte works in sql server?
How can you insert null values in a column while inserting the data?
Is it ok to shrink transaction log?
How to link tables in sql server?
What is the difference between for trigger and after trigger?
What is row-level compre?
Write SQL queries on Self Join and Inner Join.
How to sort the query output with order by clauses in ms sql server?
