4tograph's recent timeline updates 4tograph's recent timeline updates |
4tographV2EX member #389456, joined on 2019-03-05 14:17:27 +08:00 |
4tograph's recent replies
Jul 17, 2019 Replied to a topic by axwz88 › 程序员 › 最近写分页遇到一个 limit 的小问题，一直想不通 SQL 怎么写 |
@4tograph
不好意思 ，on 条件忘记写了 。
select a.school_name,b.major_name
from school a
left join major b on a.sid=b.sid
where a.sid in (select sid from school group by sid limit 2)
不好意思 ，on 条件忘记写了 。
select a.school_name,b.major_name
from school a
left join major b on a.sid=b.sid
where a.sid in (select sid from school group by sid limit 2)
Jul 17, 2019 Replied to a topic by axwz88 › 程序员 › 最近写分页遇到一个 limit 的小问题，一直想不通 SQL 怎么写 |
select a.school_name,b.major_name
from school a
left join major b
where a.sid in (select sid from school group by sid limit 2) 这样对吗？
from school a
left join major b
where a.sid in (select sid from school group by sid limit 2) 这样对吗？
Apr 4, 2019 Replied to a topic by imattlmq › Apple › HomePod 降价了 555 |
购置税降了鸭
Mar 6, 2019 Replied to a topic by GeekCourse › 推广 › 免费送 20 份《 Go 语言从入门到实战》，回帖即可参与，无需关注公众号 |
蹭一蹭
Select Language