例子如下:
phone_number user_input record_date
123 aaa 2010-4-1
123 bbb 2010-4-3
123 ccc 2010-4-4
123 ddd 2010-4-5
124 aaaa 2010-4-1
124 bbbb 2010-4-3
124 cccc 2010-4-4
124 dddd 2010-4-5
125 aaaaa 2010-4-1
125 bbbbb 2010-4-3现想从中取phone_number的3条重复记录(phone_number相同即可,随便3条),结果如下:
123 aaa 2010-4-1
123 bbb 2010-4-3
123 ccc 2010-4-4
124 aaaa 2010-4-1
124 bbbb 2010-4-3
124 cccc 2010-4-4
125 aaaaa 2010-4-1
125 bbbbb 2010-4-3请问如何用sql来实现?谢谢
phone_number user_input record_date
123 aaa 2010-4-1
123 bbb 2010-4-3
123 ccc 2010-4-4
123 ddd 2010-4-5
124 aaaa 2010-4-1
124 bbbb 2010-4-3
124 cccc 2010-4-4
124 dddd 2010-4-5
125 aaaaa 2010-4-1
125 bbbbb 2010-4-3现想从中取phone_number的3条重复记录(phone_number相同即可,随便3条),结果如下:
123 aaa 2010-4-1
123 bbb 2010-4-3
123 ccc 2010-4-4
124 aaaa 2010-4-1
124 bbbb 2010-4-3
124 cccc 2010-4-4
125 aaaaa 2010-4-1
125 bbbbb 2010-4-3请问如何用sql来实现?谢谢
from tb A
where user_input in (select user_input from tb where A.phone=phone order by user_input limit 3)
[征集]分组取最大N条记录方法征集,及散分....