combinations (not permutations) from cross join in sql

by 
T as t1
inner join
T as t2
  on t1.field < t2.field

FWIW, you can just use INNER JOIN for this, it’s not strictly a CROSS JOIN. MySQL (and perhaps some other RDBMS) treats these two types of join as identical, but in ANSI SQL, a cross join has no join condition — it’s a deliberate Cartesian product.

More Related Contents:

  1. query to find number of employees under each manager
  2. CROSS JOIN vs INNER JOIN in SQL
  3. Simplest way to do a recursive self-join?
  4. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  5. Explanation of self-joins
  6. What is SELF JOIN and when would you use it? [duplicate]
  7. What is the expected behaviour for multiple set-returning functions in SELECT clause?
  8. Mixing implicit and explicit JOINs
  9. What is a self join for? (in english)
  10. SQL INNER JOIN syntax
  11. COUNT MANY FIELDS IN ACCESS [closed]
  12. Create a date from day month and year with T-SQL
  13. IN vs OR in the SQL WHERE Clause
  14. How to handle a single quote in Oracle SQL
  15. SQL UPDATE SET one column to be equal to a value in a related table referenced by a different column?
  16. SELECT FOR UPDATE with SQL Server
  17. Get top row(s) with highest value, with ties
  18. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  19. How to group by month from Date field using sql
  20. Delete parent if it’s not referenced by any other child
  21. SQL Server Update Trigger, Get Only modified fields
  22. Grouped string aggregation / LISTAGG for SQL Server
  23. Is there a SQL implementation of PBKDF2?
  24. SQL query to get most recent row for each instance of a given key
  25. GROUP BY without aggregate function
  26. WHERE Clause to find all records in a specific month
  27. Oracle : select maximum value from different columns of the same row
  28. Oracle DB: How can I write query ignoring case?
  29. Perform JOIN query in google cloud firestore
  30. ALTER TABLE without locking the table?

Leave a Comment