Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 60501 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mona
A table join to itself is known as self join.
select emp.ename,mngr.ename from emp.empl,emp.mngr where
emp.mngrno=mngr.empno
| Is This Answer Correct ? | 15 Yes | 16 No |
Post New Answer View All Answers
explain detail about ftp in datastage?
Who are naive users?
How would you design a database for an online site, which would average a million hits a day?
How is data stored in dbms?
What is the physical representation for a many-to-many relationship?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain about the database management systems.
What are the key features of dbms?
What is the maximum length of an extended property?
Explain about relational operator join?
Explain the process of the user request and data generating?
What are the constraints on severity level in raiseerror?
Explain about query and reporting.
Which four data types cannot be used as a return type from a user-defined function?
