Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 61760 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
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain the role of indexing in databases?
explain detail about ftp in datastage?
What is database design and development?
Who are naive users?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the types of database model?
Can an extended stored procedure be called from inside a user-defined function?
What are the three basic rules which are to be followed for the relational model of the database?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How to use online Backups?
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 to read and create .LDC data files which are used by linguatic dictionary.
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?
Write short notes on manual refreshes.
