What is a self join? Explain it with an example?
- 16 Answers
- 56650 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
Explain what a database is?
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?
How to replace not in with not exist?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What are the types of database model?
Why does this query return 0?
I have a few records all are same structures data, I want to store data in multiple targets how
What is data modeling with example?
Explain the process of the user request and data generating?
Explain about the relational database?
How long can an error message be in raiseerror function?
Write short notes on manual refreshes.
explain detail about ftp in datastage?
How would you design a database for an online site, which would average a million hits a day?
