一个team表中有一组数据abcd四个球队，用一个语句查询有多少组比赛
请用SQL写出来,谢!

[解决办法]
select * from tb a,tb b, tb c ,tb d where a.col<b.col and a.col<c.col and a.col<d.col
[解决办法]
是这个样子吗？？？？？

SQL code

WITH cte AS(SELECT 'A' AS teamUNION ALL SELECT 'B'UNION ALL SELECT 'C'UNION ALL SELECT 'D')SELECT * FROM cte a,cte bWHERE a.team<b.team /*team    teamA    BA    CA    DB    CB    DC    D*/
[解决办法]
SQL code
IF object_id('tc') IS NOT NULL   DROP TABLE tc GOCREATE TABLE tc (  team VARCHAR(10))INSERT INTO tcSELECT 'A'UNION ALLSELECT 'B'UNION ALLSELECT 'C'UNION ALLSELECT 'D'SELECT Count(1)FROM   tc a       INNER JOIN tc b         ON a.team < b.team