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却不行,请问怎么会事,该如何改。谢谢
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
贴数据及要求结果出来看看