csdn

MYSQL:SELECT * FROM (SELECT * FROM USER ORDER BY USER_NAME) TMP LIMIT 0 20

在mysql中执行如SELECT * FROM (SELECT * FROM USER ORDER BY USER_NAME) TMP LIMIT 0 20这种语句，最终结果为什么没有安装user_name排序？
Houston Chronicle

How to Select a Subset in MySQL

The Structured Query Language, used in the MySQL database, has great flexibility for selecting subsets of data from database tables. SQL's SELECT statement shows data from whole tables or any subset ...