Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 61133 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?
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?
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 detail about ftp in datastage?
Explain about normal forms?
Write the fastest query to find out how many rows exist in a table?
How you can make a parameterized view?
Can an extended stored procedure be called from inside a user-defined function?
What are the three types of database design?
Explain about xml databases?
fact table and dimension table containg one to many relationship or many to one relastionship
What are the three basic rules which are to be followed for the relational model of the database?
How is data stored in dbms?
I have a few records all are same structures data, I want to store data in multiple targets how
What is the physical representation for a many-to-many relationship?
