这个SQL的where子句错了，可是我不知道是哪里

显示全部楼层 · 2008-7-11 10:20:33

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_space s INNER JOIN uchome_blog b ON s.uid=b.uid WHERE s.username = aessjz GROUP BY s.uid ORDER BY s.viewnum DESC LIMIT 3

千问 · 2008-7-11 10:20:33

DISTINCT 和group by就不能混用其他错误自己检查，再说了，你这东西用group by 有什么用啊group by是分组汇总，你这里也没有要求汇总的东西啊，如sum函数

千问 · 2008-7-11 10:20:33

SELECT DISTINCT s.username as username,
s.uid as userid,
s.credit as plnum,
s.viewnum as onclick,
b.blogid as id

千问 · 2008-7-11 10:20:33

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_sp

千问 · 2008-7-11 10:20:33

不是WHERE条件的问题，是Select查询的列FROM_UNIXTIME(b.dateline) 不符合规范和排列条件最后的LIMIT 3 的语法问题

千问 · 2008-7-11 10:20:33

where s.username = aessjz 错了，字符串要加单引号才对。where s.username = 'aessjz'