如上图,如何获取gid不重复的数据(取得下图的查询结果):
select iid,tid, git, create_time, thumb, smallimg from tableName GROUP BY gid;
无非就是where条件、排序、分组这几个吗
可以先按照gid分组,把iid较大的取出来,然后作为条件再取数
用group by分组即可:
select iid,tid, git, create_time, thumb, smallimg from tableName GROUP BY gid;
参考自:MySQL如何优化GROUP BY http://www.data.5helpyou.com/article237.html
SELECT DISTINCT * FROM Table WHERE 重复的字段
这是结果要过滤后缀吗?那你直接like *.jpg呗 这个不就可以完成后缀筛选了a
SELECT [DISTINCT] {*,column[alias],...}
FROM table
WHERE conditions
GROUP BY column
ORDER BY column ASC\DESC;
可以用group by .... having ....... order by.......