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
- 10553 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
Can you pass expressions to function parameters?
What is the difference between osql and query analyzer?
How does recursive cte works in sql server?
How do you run a trace?
Do you know what are different types of replication in sql server?
List the advantages of using stored procedures?
What is blocking?
Tell me the difference between clustered and non-clustered index?
What are click through reports?
How to create a store procedure with encryption?
What is the sql case statement used for? Explain with an example?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Give the query of getting last two records from the table in SQL SERVER?
Can we call future method from trigger?
Do you know query execution plan?
