Interested to Buy Any Domain ? << Click Here >> for more details...
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 difference sql and mysql?
Difference between global and parameter variables?
What is auto increment?
How is sql used in oracle?
How do I order by ascending in sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Why we use sql profiler?
What is record data type?
What does sign mean sql?
What is the need of merge statement?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Explain what is a field in a database and record in a database?
What is a join query?
how to run 'mysql' commands from a batch file? : Sql dba
Can we use update in sql function?
