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
- 10788 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
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Can the query output be sorted by multiple columns in ms sql server?
How to enter date and time literals in ms sql server?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Can we use where clause in union?
How to add more data to the testing table in ms sql server?
how to take backup bcp out for a column in table in sql server?
What are dml triggers and types of dml triggers?
List the ways in which dynamic sql can be executed?
What happens when converting big values to numeric data types?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is subquery in sql?
Does a full backup include transaction log?
What do you mean by subquery?
what is normalization? Explain different levels of normalization? : Sql server database administration
