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
- 8681 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
what is the difference between openrowset and openquery?
Explain the xml support sql server extends?
Can two tables share the same primary key?
What is primary key index?
What is the Main Difference between ACCESS and SQL SERVER?
Explain the concept of view and Types of views in SQL server?
How many types of attribute relationships are there? : sql server analysis services, ssas
Do you know what are the steps to process a single select statement?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What do you understand by triggers?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Can coalesce return null?
How to list all triggers in the database with sys.triggers in ms sql server?
What are the restrictions that views have to follow?
