SELECT GROUP_CONCAT(DISTINCT `goods_id` ORDER BY `lv`) as ids FROM base_guild_shopids
321401,321301,222001,221701,221001,111001,511103,...SELECT DISTINCT `goods_id`,lv FROM base_guild_shop ORDER BY `lv`,goods_id DESC
goods_id | lv
321401 1
321301 1
222001 1
221701 1
221001 1
111001 1
511103 2
...为什么ids字段的排序是降序的?
321401,321301,222001,221701,221001,111001,511103,...SELECT DISTINCT `goods_id`,lv FROM base_guild_shop ORDER BY `lv`,goods_id DESC
goods_id | lv
321401 1
321301 1
222001 1
221701 1
221001 1
111001 1
511103 2
...为什么ids字段的排序是降序的?
解决方案 »
- 新手求助:如何判断ABCD档,并送到指定的表中
- 为什么mysql子查询中不能用limit而临时表能呢?
- ■安装mysql-5.0.19-win32时出现的奇怪问题,大家帮忙!!!在线等...
- 为什么我装的mysql版本sql语句不支持子句?
- 关于Limit 的问题?不知是MySQL的bug?
- 求救:can not connect to mysql server(10061)是怎么回事?
- msyql存储过程查询出某条数据在数据库所有表的表名以及所在表的行数
- SQL:两表查询和删除,这么写有问题吗?
- 这个sql语句很难啊,求高手解答
- 求助mysql索引无效了,求指点
- 求会mysql的帮忙看下,为什么同一段sql查询语句mssql和mysql差距这么大
- sql语句求助
SELECT DISTINCT `goods_id`,lv FROM base_guild_shop ORDER BY `lv`,goods_id DESC
SELECT DISTINCT `goods_id`,lv FROM base_guild_shop ORDER BY `lv`,goods_id DESC
我指的是第一条SQL语句。