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
- 10616 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / varunkumar
by using unions we can do it create two tables separetly and
apply union in between two tables .
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain trigger classes i.e. Instead of and after trigger?
How to create an identity column?
What do you think of this implementation? Can this be implemented better?
What is the difference between a view and a stored procedure?
Explain intellisense for query editing
What is store procedure? How do they work? When do you use?
If the job running very slow what is the action you do
Is ssrs support other database except ms sql server?
What does the update command do?
what is nonclustered index
What happens if ntwdblib.dll is missing on your machine?
Why we use trigger in sql server with example?
Write down the syntax and an example for create, rename and delete index?
How do you make a trace?
What is a not null constraint?
