What is Self Join?

Answer Posted / shekar

the concept of joining a table with it self in called "self
join"

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete a trigger?

574


How to use copy and concatenate commands in SQL?

597


How to create a view using data from another view?

563


State the difference between local and global temporary tables?

560


Tell me the difference between clustered and non-clustered index?

510






How can I tell if sql server is 32 or 64 bit?

497


How can we determine what objects a user-defined function depends upon?

512


How do I connect to sql server database?

474


What is acid properties?

590


How do you identify a foreign key?

599


can any body tell me how to know the password of current user in sql server

1573


Is it possible to update the views? If yes, how, if not, why?

541


What is the sql profiler?

539


Do you know what are the restrictions that views have to follow?

622


Mention the different types of triggers?

545