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
- 10818 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
How to use transact-sql statements to access the database engine?
What is log cache in sql server?
Explain how to send email from sql database?
explain different types of cursors? : Sql server database administration
What does it mean if @@cursor_row returns a negative number?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is merge replication?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is user-defined multi-statement table-valued function?
What is the difference between primary key and unique constraints?
Explain tablesample?
What is subquery in sql?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Can group functions be used in the order by clause in ms sql server?
