高人请看SELECT DISTINCT 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 3这是一段多表查询语句,我现在想查询出的数据先按b.blogid DESC排序,然后再进行分组(group by s.uid)请问怎样做?谢谢了
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 id DESC
GROUP BY userid
select uid from (
SELECT DISTINCT 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 3)
a
group by uid
SELECT DISTINCT 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 3)
a
group by uid
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 3) a
group by userid
SELECT DISTINCT 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 3)
a
group by uid
可以直接接用uid吗?我是了用userid和s.uid都不行,同时好像a group by uid这个是不是也要盖盖,我不太懂,高人解
SELECT DISTINCT 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 3)
a
group by userid