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 |
Post New Answer View All Answers
What is the difference between left join and right join?
what are date and time data types? : Sql dba
tell me about various levels of constraint. : Sql dba
what is offset-fetch filter in tsql? : Transact sql
What is difference between hql and native sql?
Can we use ddl statements in stored procedure?
what is 'mysqlcheck'? : Sql dba
how to drop an existing view in mysql? : Sql dba
what are null values? : Sql dba
How to revise and re-run the last sql command?
What are inner and outer joins examples of both?
Write a sql select query that only returns each name only once from a table?
how to enter characters as hex numbers? : Sql dba
The select into statement is most often used to create backup copies of tables or for archiving records?
How many sql are there?