How do I compare 2 rows from the same table (SQL Server)?

by

You can join a table to itself as many times as you require, it is called a self join.

An alias is assigned to each instance of the table (as in the example below) to differentiate one from another.

SELECT a.SelfJoinTableID
FROM   dbo.SelfJoinTable a
       INNER JOIN dbo.SelfJoinTable b
         ON a.SelfJoinTableID = b.SelfJoinTableID
       INNER JOIN dbo.SelfJoinTable c
         ON a.SelfJoinTableID = c.SelfJoinTableID
WHERE  a.Status="Status to filter a"
       AND b.Status="Status to filter b"
       AND c.Status="Status to filter c"

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. How do I UPDATE from a SELECT in SQL Server?
  3. Get top 1 row of each group
  4. How to return only the Date from a SQL Server DateTime datatype
  5. How to calculate age (in years) based on Date of Birth and getDate()
  6. CROSS JOIN vs INNER JOIN in SQL
  7. Referring to a Column Alias in a WHERE Clause
  8. Function vs. Stored Procedure in SQL Server
  9. converting Epoch timestamp to sql server(human readable format)
  10. How to get difference between two rows for a column field?
  11. How do I split a delimited string so I can access individual items?
  12. Common Table Expression, why semicolon?
  13. What’s the best way to select the minimum value from several columns?
  14. T-SQL split string based on delimiter
  15. Counting DISTINCT over multiple columns
  16. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  17. Why use Select Top 100 Percent?
  18. How to check if a stored procedure exists before creating it
  19. Correct use of transactions in SQL Server
  20. How do I prevent a database trigger from recursing?
  21. What is the Null Character literal in TSQL?
  22. SQL Server : SUM() of multiple rows including where clauses
  23. How to combine results of two queries into a single dataset
  24. Executing SQL Server Agent Job from a stored procedure and returning job result
  25. how does SELECT TOP works when no order by is specified?
  26. SQL Server FOR XML Path make repeating nodes
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Group consecutive rows of same value using time spans
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment