Mysql如何限制返回数量并排序?# Database - 数据库
b*k
1 楼
我的mysql不支持嵌套查询,有没有简单的方法实现(不用临时表等复杂方法):
((select xxx from yyy limit 1000) order by zzz) limit 0,50 ?
((select xxx from yyy limit 1000) order by zzz) limit 0,50 ?
b*e
2 楼
Mysql doesn't support nested query right now. It might be in the future
version 5.0.
Mysql does support limit keyword.
【在 b*******k 的大作中提到】
: 我的mysql不支持嵌套查询,有没有简单的方法实现(不用临时表等复杂方法):
: ((select xxx from yyy limit 1000) order by zzz) limit 0,50 ?
version 5.0.
Mysql does support limit keyword.
【在 b*******k 的大作中提到】
: 我的mysql不支持嵌套查询,有没有简单的方法实现(不用临时表等复杂方法):
: ((select xxx from yyy limit 1000) order by zzz) limit 0,50 ?
相关阅读
Re: How to create a new database under SQL 7.0 from remote host?紧急求助MS SQL server or PostgreSQL server?我的oracle 怎么了?FileMaker Prohow to call pl/sql in vb?在win2000+sql server 2000中怎么加入中文?[转载] Anybody have configured Oracle 9i Under Linux?ACCESS问题, 请教！请教一个问题招聘oracle9作者How to populate data from text or MS ACCESS file to Oracle Database?[转载] ASP问题： Operation must use an updateable queryHELP: Oracle ENTERPRISE Manager Configuration Assistant is Missing[转载] JAVA连ORACLE的一个诡异问题Help need on writing data to Oracle CLOB!How to change Default Buffer Size for Long Columns?(string size exceeds 1K)How to transfer values between forms in Access?where to find Oracle adm's handbook, developer guide BOOK?Problem Running MySql on W2K