Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 61633 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vijayan.t
A table join to itself is known as self join.
select e1.empid,e1.empname,e1.empmgrname where empmgrid =
empid;
here in a single table e1 having three fields(employee id,
employee name,manager id)one employee's manager id is
another one employee's employee id so compare that 2 ids and
we can get the particular employee's manager name...
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
How to combine two function together?
Explain about query and reporting.
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
How can you log an error to the server event log from a stored procedure?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What is DB Development software?
What is normalization? Explain different levels of normalization?
Which four data types cannot be used as a return type from a user-defined function?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How would you design a database for an online site, which would average a million hits a day?
How can you fix a poorly performing query?
How to customize error conditions.
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
explain detail about ftp in datastage?
