sql如何把每行的数据排序小弟在学斯坦佛的免费sql课作业里面有一题：For every pair of student
1个回答

select h1.name, h1.grade, h2.name, h2.grade from Likes l1, Likes l2, Highschooler h1, Highschooler h2

where l1.ID1=l2.ID2 and l2.ID1=l1.ID2 and l1.ID1=h1.ID and l1.ID2=h2.ID

and h1.name

1年前

追问

2

hh与馒头的故事

举报

不行啊

加了以后就变成

Cassandra 9 Gabriel 9

第二行都不出现了

举报

shipotianjing

那你再把我的整个语句执行一遍看看出不出来

select h1.name, h1.grade, h2.name, h2.grade from Likes l1, Likes l2, Highschooler h1, Highschooler h2

where l1.ID1=l2.ID2 and l2.ID1=l1.ID2 and l1.ID1=h1.ID and l1.ID2=h2.ID

and h1.name

相关问题