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
- 10543 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / shankaranarayanan v
select eid,ename,dept,desg,salary from a,b
where a.eid=b.sid
(when a.eid=b.sid)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How can you find out how many rows returned in a cursor?
Define self join in sql server joins?
What are the different types of collation sensitivity?
Tell me what do we need queues in sql service broker?
How do I find the default sql server instance?
How can you start sql server in different modes?
How to create an multi-statement table-valued function?
How to create view in stored procedure sql server?
Explain what is public role in sql server?
What is SQL Azure Fabric?
What is the meaning of resultset type_scroll_insensitive?
What are translations and its use? : sql server analysis services, ssas
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is the cartesian product of the table?
in the physical file layout, where should the transaction log be stored in relation to the data file?
