【SQL语句】怎么根据需求除去某列重复结果

Question

本帖最后由 duanml61 于 2012-08-28 14:09:15 编辑

Answer 1

试试这个：
select recvperson, max(sendTime) as sendTime,sendperson from ofHistroy where sendperson='admin' group by recvperson order by sendTime desc;

Answer 2

select recvperson,min(sendTime ) ,min(sendperson )
from ofHistroy 
group by recvperson

Answer 3

select *
from ofHistroy  
group by recvperson

Answer 4

多谢 ，这个可以mysql> select recvperson,sendTime,sendperson from ofHistroy where sendperson='[email protected]
' order by sendTime desc;
+----------------------+---------------------+---------------------+
| recvperson           | sendTime            | sendperson          |
+----------------------+---------------------+---------------------+
| 13012345678@ooooooo | 2012-08-28 15:31:27 | [email protected] |
| 13212345678@ooooooo | 2012-08-28 15:30:32 | [email protected] |
| 13312345678@ooooooo | 2012-08-28 15:30:28 | [email protected] |
| 13012345678@ooooooo | 2012-08-28 14:45:55 | [email protected] |
| 13012345678@ooooooo | 2012-08-28 14:42:18 | [email protected] |
| 13012345678@ooooooo | 2012-08-28 14:42:09 | [email protected] |
| 13012345678@ooooooo | 2012-08-28 14:40:17 | [email protected] |
| 13012345678@ooooooo | 2012-08-28 14:39:09 | [email protected] |
+----------------------+---------------------+---------------------+
8 rows in set
mysql> select recvperson, max(sendTime) as sendTime,sendperson from ofHistroy where sendperson='[email protected]' group by recvperson order by sendTime desc;+----------------------+---------------------+---------------------+
| recvperson           | sendTime            | sendperson          |
+----------------------+---------------------+---------------------+
| 13012345678@ooooooo | 2012-08-28 15:31:27 | [email protected] |
| 13212345678@ooooooo | 2012-08-28 15:30:32 | [email protected] |
| 13312345678@ooooooo | 2012-08-28 15:30:28 | [email protected] |
+----------------------+---------------------+---------------------+
3 rows in set