What is a self join? Explain it with an example?
- 16 Answers
- 58482 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
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
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
In which table collections errors are stored.
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Which data type cannot be used as a parameter in a udf?
What is an application role and explain a scenario when you would use one?
In which database can extended stored procedures be added?
Explain about a primary key?
Can an extended stored procedure be called from inside a user-defined function?
Explain about relational operator join?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Explain about xml databases?
How can you log an error to the server event log from a stored procedure?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Explain about query and reporting.
