Home >Database >Mysql Tutorial >列出 OSCHINA 被收藏最多的前 10 个软件
列出 OSCHINA 被收藏最多的前 10 个软件
- WBOYOriginal
- 2016-06-07 14:56:211224browse
无详细内容 OSCHINA SELECT p.name FROM osc_favorites f, osc_projects p WHERE f.obj_id = p.id AND f.type = 1 GROUP by f.obj_id ORDER BY count(f.obj_id) DESC LIMIT 10
OSCHINASELECT p.name FROM osc_favorites f, osc_projects p WHERE f.obj_id = p.id AND f.type = 1 GROUP by f.obj_id ORDER BY count(f.obj_id) DESC LIMIT 10
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Access7.4 怎样设置字段的属性Next article：sqlserver 查询数据库中所有表的metadata