select * from (
SELECT s.username as username,s.uid as userid,s.credit as plnum,s.viewnum as onclick,b.blogid as id,b.subject as title,FROM_UNIXTIME(b.dateline) as newstime FROM uchome_blog b INNER JOIN uchome_space s ON b.uid=s.uid ORDER BY b.blogid DESC LIMIT 10)
a
group by userid LIMIT 3这是我用的查询语句,其中内部的多表查询不是问题,关键是a group by userid后该如何加入排序字段的问题,我想让结果按内部的b.blogid来排序,可是我在a group by userid 放入 order by a group by userid却不行,请问怎么会事,该如何改。谢谢
SELECT s.username as username,s.uid as userid,s.credit as plnum,s.viewnum as onclick,b.blogid as id,b.subject as title,FROM_UNIXTIME(b.dateline) as newstime FROM uchome_blog b INNER JOIN uchome_space s ON b.uid=s.uid ORDER BY b.blogid DESC LIMIT 10)
a
group by userid LIMIT 3这是我用的查询语句,其中内部的多表查询不是问题,关键是a group by userid后该如何加入排序字段的问题,我想让结果按内部的b.blogid来排序,可是我在a group by userid 放入 order by a group by userid却不行,请问怎么会事,该如何改。谢谢
解决方案 »
- 求个数据库监控软件。
- MySQL如何解决中文插入问题
- 求与当前时间一前一后的记录的sql
- MySQL中的数据量太大了,怎么办
- mysql中修改字段属性语句是如何写的呀
- 怎样分几次向MySQL数据库中insert into数据?
- MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout ex
- mysql 配置文件 my.cnf 中myisam-recover-options = backup,force
- 请问怎么实现动态行转列?(具体哪些列取自另一表)【附全部建表SQL】如果数据库设计的不合理还望大神们多多指教
- mysql实时同步redis
- mysql中的中文乱码问题 急 高手帮帮忙
- php连mysql问题
select userid from (
SELECT s.username as username,s.uid as userid,s.credit as plnum,s.viewnum as onclick,b.blogid as id,b.subject as title,FROM_UNIXTIME(b.dateline) as newstime FROM uchome_blog b INNER JOIN uchome_space s ON b.uid=s.uid ORDER BY b.blogid DESC LIMIT 10)
a
group by userid order by blogid LIMIT 3
SELECT s.username as username,s.uid as userid,s.credit as plnum,s.viewnum as onclick,b.blogid as id,b.subject as title,FROM_UNIXTIME(b.dateline) as newstime FROM uchome_blog b INNER JOIN uchome_space s ON b.uid=s.uid ORDER BY b.blogid DESC LIMIT 10)
a
group by userid oedr by id LIMIT 3
贴数据及要求结果出来看看