Answer Posted / anbu
Self join is defined as a table is viewd by two different
ways and then the join can be done with the same table.
By another way the definition is 'A table can be joined
with itself using sel join'.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is the use of partition by in sql?
Is sql the best database?
What is dynamic query?
How do we accept inputs from user during runtime?
what does the t-sql command ident_incr does? : Transact sql
What does the base_object_type column shows in the user.triggers data dictionary view?
What is a field in a database?
What is the difference between sum and count in sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is AUTH_ID and AUTH_USER in pl/sql ?
Can we use two order by clause in query?
What is triggering circuit?
How many scalar data types are supported in pl/sql?
Why sql query is slow?
