Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 60625 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ganesh
A join joins with itself is called self join
Working with self joins we use Alias tables
| Is This Answer Correct ? | 96 Yes | 21 No |
Post New Answer View All Answers
What is normalization? Explain different levels of normalization?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
Who are naive users?
How to generate OIDS
How would you design a database for an online site, which would average a million hits a day?
I have a few records all are same structures data, I want to store data in multiple targets how
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 main phases of database development?
Explain about network model?
Write the fastest query to find out how many rows exist in a table?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain the role of indexing in databases?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How can you fix a poorly performing query?
Where is dbms used?
