Explain SELF JOIN ?

Answer Posted / dinesh rathod

Self join is just like any other join, except that two instances of the same table will be joined in the query

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

550


Explain acid?

600


Why is sql server log file full?

530


What will be query used to get the list of triggers in a database?

541


Explain the stored procedure?

627






What is sql server english query?

537


What is open database communication (odbc)?

567


Do you know what is a trace frag? Where do we use it?

548


What are magic tables in sql server?

619


How global temporary tables are represented and its scope?

547


How to create prepared statements using odbc_prepare()?

563


When is update_statistics command used?

572


What is a transactions?

596


What is sparse columns of sql server 2008?

595


What is implicit cursors?

547