mysql 重复记录显示1条怎么做? title11223344要求select输出 title 1 2 3 4 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select distinct(title) from <table_name> 希望楼主不会改变问题的描述。mysql> select * from t_fnzh005;+-------+| title |+-------+| 1 || 1 || 2 || 2 || 3 || 3 || 4 || 4 |+-------+8 rows in set (0.02 sec)mysql> select distinct(title) from t_fnzh005;+-------+| title |+-------+| 1 || 2 || 3 || 4 |+-------+4 rows in set (0.00 sec)mysql> select title from t_fnzh005 group by title;+-------+| title |+-------+| 1 || 2 || 3 || 4 |+-------+4 rows in set (0.00 sec)mysql> distinct 或则group by 都可以满足楼主的要求~ select distinct(title) from t;select title from t group by title;如果想要查询的结果包括统计数的话,只能用group by了,select title,count(*) from t group by title; 简单sql语句求助。。。。。。。。。!!!!!!!! mysql存储过程的问题 我在Windows下安装了MySQL5,数据库的储存路径在哪啊? MySql数据库 查询问题 请教高手解释下MYSQL中LIMIT和OFFSET的用法 关于表和字段问题,经验者请进 求存储过程,进来的有分 我看过faq了,对\转义符号还是有疑惑,望大家帮忙 请教使用innodb表的数据库备份与恢复? VC可不可以不用ADO直接连接MYSQL,怎么做? 请问,数据库崩溃,有没有什么办法,可以让linux系统自己自动恢复? MySQL做了主从复制,都需要注意一些什么呢?
+-------+
| title |
+-------+
| 1 |
| 1 |
| 2 |
| 2 |
| 3 |
| 3 |
| 4 |
| 4 |
+-------+
8 rows in set (0.02 sec)mysql> select distinct(title) from t_fnzh005;
+-------+
| title |
+-------+
| 1 |
| 2 |
| 3 |
| 4 |
+-------+
4 rows in set (0.00 sec)mysql> select title from t_fnzh005 group by title;
+-------+
| title |
+-------+
| 1 |
| 2 |
| 3 |
| 4 |
+-------+
4 rows in set (0.00 sec)mysql>
select title,count(*) from t group by title;