What is a self join for? (in english)

by

The reason why the employee-manager example is so common, is because it hits the nail on the head. A self join on a table looks for pairs of rows, like any join, but with both rows coming from the same table. Nothing special really.

More Related Contents:

  1. query to find number of employees under each manager
  2. Simplest way to do a recursive self-join?
  3. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  4. Explanation of self-joins
  5. What is SELF JOIN and when would you use it? [duplicate]
  6. What are projection and selection?
  7. combinations (not permutations) from cross join in sql
  8. Postgresql query between date ranges
  9. What does collation mean?
  10. Backup a single table with its data from a database in sql server 2008
  11. How to check if a column exists before adding it to an existing table in PL/SQL?
  12. How in H2DB get sql dump like in MySql?
  13. How to use SQL LIKE condition with multiple values in PostgreSQL?
  14. SQL Server equivalent to MySQL’s EXPLAIN
  15. How to get the last day of month in postgres?
  16. How can I solve ORA-00911: invalid character error?
  17. Try_Convert for SQL Server 2008 R2
  18. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  19. SQL Server variable scope in a stored procedure
  20. Determine if one coordinate is in radius of another
  21. Entity Framework Skip/Take is very slow when number to skip is big
  22. SQL SERVER DATETIME FORMAT
  23. SQL: Using DATEADD with bigints
  24. SQL WITH clause example [duplicate]
  25. Insert all values of a table into another table in SQL
  26. Oracle ‘Partition By’ and ‘Row_Number’ keyword
  27. converting int to real in sqlite
  28. What is difference between foreign key and reference key?
  29. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?
  30. Concat all column values in sql

Leave a Comment