Joining the Table data it self is called self join,it will work based on th

what is self join and how it works??

Question Posted / srinu

Answer Posted / srinu

Joining the Table data it self is called self join,it will work based on the join condition

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between left join and right join?

888

what are date and time data types? : Sql dba

930

tell me about various levels of constraint. : Sql dba

990

what is offset-fetch filter in tsql? : Transact sql

891

What is difference between hql and native sql?

1092

Can we use ddl statements in stored procedure?

1095

what is 'mysqlcheck'? : Sql dba

959

how to drop an existing view in mysql? : Sql dba

995

what are null values? : Sql dba

900

How to revise and re-run the last sql command?

1099

What are inner and outer joins examples of both?

879

Write a sql select query that only returns each name only once from a table?

959

how to enter characters as hex numbers? : Sql dba

993

The select into statement is most often used to create backup copies of tables or for archiving records?

1001

How many sql are there?

924