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
- 10603 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
whats new about truncate in sql server 2008?
How to convert numeric expression data types using the cast() function?
How many full-text indexes can a table have?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
List out different types of normalizations in sql server and explain each of them?
What are the dmvs? : sql server database administration
How many replicas are maintained for each SQL Azure database?
Tell me what is de-normalization and what are some of the examples of it?
What are points to remember while using the fillfactor argument?
Explain database normalization?
How to download and install microsoft sql server management studio express?
Can a unique index be created on a column, which contains null?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is recompile sql server?
What is buffer cash and log cache in sql server?
