34,588
社区成员
发帖
与我相关
我的任务
分享
--> 测试数据:[tbl]
if object_id('[tbl]') is not null drop table [tbl]
create table [tbl](
[uuid] varchar(16),
[goodsid] bigint,
[evaluate] varchar(500)
)
insert [tbl]
select '139b9e8c65d749e9',13234352525,'很大,很甜,很好' union all
select '14ad01ae387749e9',13234352525,'好大的个哦,很甜,吃完了再来~~~' union all
select '18a44dfee43349e9',13234352525,'很不错,家里很喜欢~肉大,甜死了~' union all
select '1a5c546972a749e9',13234352525,'宝贝收到了,很好吃,味道很好,5分好评了' union all
select '1ba3353c6ec209e9',13234352525,'特别喜欢这个枣,个大,肉厚,核小.简直是枣子中的极品啊!' union all
select '1d92bebb61a029e9',13234352525,'很好吃,价格也很优惠!卖家人很好呢!物流也非常给力!我是吃过了才来评价的哈!' union all
select '20f1fd6933e249e9',13234352525,'一下子买了好多,掌柜人很细心一个都没落下哦,很好吃,满意,好评`.' union all
select '230c629acaa829e9',13234352525,'全5分.买了做年货的,开心果、巴旦木、松子还没吃,不过看上去很好,个头都比较大,相信味道肯定不错.红枣已经吃了,肉很紧,很甜,核小,妈妈说是没有制过的,所以马上又买了几斤用来送人.烤鱿片有点甜,很有嚼劲,也很好吃.以后要买坚果、红枣和零食都可以直接在这家买了..老板人很实在,生意肯定越来越好!' union all
select '23b637b6588f49e9',13234352525,'帮同事购买的,同事说很好.' union all
select '285f03b7940149e9',13234352525,'新疆枣子,果然不错.以后再来' union all
select '2862d48057e949e9',13234352525,'很不错.' union all
select '2a2ef48bdf3749e9',13234352525,'老板不错,哈哈~我要把你家吃穷!嘿嘿~' union all
select '2c7fa97ab039c9e9',13234352525,'一如既往的好!' union all
select '2c85c6a59939b9e9',13234352525,'恩枣个大的有霸气,煮在稀饭里也很檽' union all
select '2cd5ea72d9408cef',13379084522,'肉有点枯了.' union all
select '32e72160047749e9',13234352525,'超值的枣子,味道很好,分量也足.' union all
select '337e3efdc47749e9',13234352525,'妈妈很稀罕吃,真不错~同事也都要买' union all
select '3b2e2d456e2949e9',13234352525,'比我想像的大多了,甜!!!!' union all
select '3bcc5f26457749e9',13234352525,'不错,够大颗.很新鲜哦' union all
select '3c886c9d8a8f2fe9',13234352525,'枣子个个都挺好的!赞一个' union all
select '3df8d4db352849e9',13234352525,'这个枣子也不错,直接吃,泡水喝都挺好的,我还试着往豆浆里打了,很香的红枣味.满意.都五分,以后来了要多给优惠哈.呵呵' union all
select '3f717c3cb22549e9',13234352525,'买了几次了,哈哈' union all
select '419d52d20e2171e9',13234352525,'个头挺大 有点干巴' union all
select '42abd9efed8bc8e9',13234352525,'枣子个头很大,不错' union all
select '4419d0e30f3749e9',13234352525,'很棒的枣子,我气色好了很多.' union all
select '4a856b84aa29f3e9',13234352525,'不错,好吃,挺有肉的,介绍的不错哦,好评' union all
select '4b043783b31749e9',13234352525,'个大肉厚,味道甜,就是要洗.不是免洗的哇.....' union all
select '4cb392155d6f4de9',13234352525,'卖家服务态度超好,宝贝真的很不错的,口味很好,吃好了还会在来购买的!' union all
select '4e137531c78fc9e9',13234352525,'好靓的红枣,好吃不贵' union all
select '53450bc4b895c1e9',13234352525,'不错,好东西' union all
select '53f2e2a1793149e9',13234352525,'很甜的说,是买给宝宝吃的' union all
select '542681df428549e9',13234352525,'红枣真的很好喔,值得推荐.' union all
select '59ef004de33b29e9',13234352525,'枣完全是很脏很脏的那种,洗都洗不干净' union all
select '5d8c4f276b01406a',12790821726,'很不错,送人了,嘻嘻!!' union all
select 'c0ae545630d749e9',13234352525,'这个吃得最快了.一斤几下吃完了.' union all
select 'c20487f00c7749e9',13234352525,'最爱的了,个头大,肉厚,核小,简直是枣中的极品啊!' union all
select 'c4a437e84cf7c9e9',13234352525,'很好吃,个大,还很甜' union all
select 'c61aab262e4f49e9',13234352525,'个头好大啊' union all
select 'c64c5f4a52a7c9e9',13234352525,'很好的大枣啊,买了n次了,还有客服很和蔼可亲啊' union all
select 'c7e5e08dc1ed49e9',13234352525,'枣好空,不饱满,不好吃' union all
select 'c8c6d4b047749e9',13234352525,'质量不错,有机会再来' union all
select 'cc977f32cc9069e9',13234352525,'枣子很甜,我推荐' union all
select 'ce1f1bdc4faf49e9',13234352525,'枣子很脏,不像是新枣,里面有坏的,不过个头挺大' union all
select 'd03e3f052b549e9',13234352525,'大枣真的很大,还很甜,真的很赞,已经买第二次了' union all
select 'd08dab575c3749e9',13234352525,'好评!经常来这里买东西挺不错的、' union all
select 'd25ffbd81c7925e9',13234352525,'好吃 下次还来' union all
select 'd2a2f0c2167749e9',13234352525,'很不错的商家很给力的商品!~亲们我们一定会在合作的的哦!~~掌柜的人超级好嘻嘻' union all
select 'd3ee14a83bf749e9',13234352525,'好大一粒,抵,快递很给力' union all
select 'd7f85fdca01125e9',13234352525,'不错哦' union all
select 'd945aad086ff49e9',13234352525,'补血的,卖给妈妈吃的,一日三颗枣....下一句你知道吧.' union all
select 'd9defacfd5f749e9',13234352525,'一般吧' union all
select 'dbfc443c2adc79e9',13234352525,'枣很甜,肉厚,很好吃.' union all
select 'df4b7f733ccec9e9',13234352525,'很快,东西很好,推荐给同事了,下次还回来' union all
select 'e07da4ae6e4fa9e9',13234352525,'真是个大啊!~而且肉厚味甜!妈妈吃了赞不绝口!~下次还来买!!' union all
select 'e1e0aad5a3a3c9e9',13234352525,'先打款期待中' union all
select 'e5640a39fdb749e9',13234352525,'很实惠的好吃!~掌柜的家的东西一如既往的好的哦!~五分好评!~' union all
select 'e67130f8afb349e9',13234352525,'新疆的就是好' union all
select 'e8d772c372ce89e9',13234352525,'很好!' union all
select 'ef87fbcb6bf749e9',13234352525,'帮朋友买的,说枣子有点脏,不干净,要洗了才吃' union all
select 'f06a8e3f7a5e59e9',13234352525,'枣的个儿挺大的,吃了几颗,糯糯的,甜甜的,皮比较薄,肉还挺多的,籽也比较小,下次还来这边买,掌柜的可要给我便宜点呀' union all
select 'f1ef4ee8c3a7c9e9',13234352525,'不错的枣子,个头大,肉厚实.' union all
select 'f9c97a99747749e9',13234352525,'枣不错,挺大的,肉厚,也很甜,全五分.' union all
select 'fa31272ebbb6fbe9',13234352525,'个好大,有点麻烦啊,得洗了再吃' union all
select 'faa8e61ccf01c9e9',13234352525,'评价方未及时做出评价,系统默认好评!' union all
select 'fb40b553791fd0e9',13234352525,'就是好脏啊' union all
select 'fb4f093c1c9629e9',13234352525,'好枣,核小肉多,口感好,喜欢吃.补血养气佳品,常吃益处多,生吃,泡茶,炖汤都可以.吃完再来买.很好的店家,一次买了好多样,发货快,包装细.全5分!' union all
select 'fc6123e60aa349e9',13234352525,'枣的品质不怎么样' union all
select 'fcde31376d9879e9',13234352525,'很不错啊' union all
select 'fe05e0a169c269e9',13234352525,'红枣很好吃额,营养'
select top 3 uuid,goodsid,evaluate from(
select ROW_NUMBER()over(partition by goodsid order by newid()) as id,* from tbl)a
order by id
/*
uuid goodsid evaluate
59ef004de33b29e9 13234352525 枣完全是很脏很脏的那种,洗都洗不干净
5d8c4f276b01406a 12790821726 很不错,送人了,嘻嘻!!
2cd5ea72d9408cef 13379084522 肉有点枯了.
*/
select top 6 uuid,goodsid,evaluate from(
select ROW_NUMBER()over(partition by goodsid order by newid()) as id,* from tbl)a
order by id
/*
uuid goodsid evaluate
fc6123e60aa349e9 13234352525 枣的品质不怎么样
5d8c4f276b01406a 12790821726 很不错,送人了,嘻嘻!!
2cd5ea72d9408cef 13379084522 肉有点枯了.
cc977f32cc9069e9 13234352525 枣子很甜,我推荐
2862d48057e949e9 13234352525 很不错.
42abd9efed8bc8e9 13234352525 枣子个头很大,不错
*/
--更正一下,这下应该可以了
--> 测试数据:[tbl]
if object_id('[tbl]') is not null drop table [tbl]
create table [tbl](
[uuid] varchar(16),
[goodsid] bigint,
[evaluate] varchar(500)
)
insert [tbl]
select '139b9e8c65d749e9',13234352525,'很大,很甜,很好' union all
select '14ad01ae387749e9',13234352525,'好大的个哦,很甜,吃完了再来~~~' union all
select '18a44dfee43349e9',13234352525,'很不错,家里很喜欢~肉大,甜死了~' union all
select '1a5c546972a749e9',13234352525,'宝贝收到了,很好吃,味道很好,5分好评了' union all
select '1ba3353c6ec209e9',13234352525,'特别喜欢这个枣,个大,肉厚,核小.简直是枣子中的极品啊!' union all
select '1d92bebb61a029e9',13234352525,'很好吃,价格也很优惠!卖家人很好呢!物流也非常给力!我是吃过了才来评价的哈!' union all
select '20f1fd6933e249e9',13234352525,'一下子买了好多,掌柜人很细心一个都没落下哦,很好吃,满意,好评`.' union all
select '230c629acaa829e9',13234352525,'全5分.买了做年货的,开心果、巴旦木、松子还没吃,不过看上去很好,个头都比较大,相信味道肯定不错.红枣已经吃了,肉很紧,很甜,核小,妈妈说是没有制过的,所以马上又买了几斤用来送人.烤鱿片有点甜,很有嚼劲,也很好吃.以后要买坚果、红枣和零食都可以直接在这家买了..老板人很实在,生意肯定越来越好!' union all
select '23b637b6588f49e9',13234352525,'帮同事购买的,同事说很好.' union all
select '285f03b7940149e9',13234352525,'新疆枣子,果然不错.以后再来' union all
select '2862d48057e949e9',13234352525,'很不错.' union all
select '2a2ef48bdf3749e9',13234352525,'老板不错,哈哈~我要把你家吃穷!嘿嘿~' union all
select '2c7fa97ab039c9e9',13234352525,'一如既往的好!' union all
select '2c85c6a59939b9e9',13234352525,'恩枣个大的有霸气,煮在稀饭里也很檽' union all
select '2cd5ea72d9408cef',13379084522,'肉有点枯了.' union all
select '32e72160047749e9',13234352525,'超值的枣子,味道很好,分量也足.' union all
select '337e3efdc47749e9',13234352525,'妈妈很稀罕吃,真不错~同事也都要买' union all
select '3b2e2d456e2949e9',13234352525,'比我想像的大多了,甜!!!!' union all
select '3bcc5f26457749e9',13234352525,'不错,够大颗.很新鲜哦' union all
select '3c886c9d8a8f2fe9',13234352525,'枣子个个都挺好的!赞一个' union all
select '3df8d4db352849e9',13234352525,'这个枣子也不错,直接吃,泡水喝都挺好的,我还试着往豆浆里打了,很香的红枣味.满意.都五分,以后来了要多给优惠哈.呵呵' union all
select '3f717c3cb22549e9',13234352525,'买了几次了,哈哈' union all
select '419d52d20e2171e9',13234352525,'个头挺大 有点干巴' union all
select '42abd9efed8bc8e9',13234352525,'枣子个头很大,不错' union all
select '4419d0e30f3749e9',13234352525,'很棒的枣子,我气色好了很多.' union all
select '4a856b84aa29f3e9',13234352525,'不错,好吃,挺有肉的,介绍的不错哦,好评' union all
select '4b043783b31749e9',13234352525,'个大肉厚,味道甜,就是要洗.不是免洗的哇.....' union all
select '4cb392155d6f4de9',13234352525,'卖家服务态度超好,宝贝真的很不错的,口味很好,吃好了还会在来购买的!' union all
select '4e137531c78fc9e9',13234352525,'好靓的红枣,好吃不贵' union all
select '53450bc4b895c1e9',13234352525,'不错,好东西' union all
select '53f2e2a1793149e9',13234352525,'很甜的说,是买给宝宝吃的' union all
select '542681df428549e9',13234352525,'红枣真的很好喔,值得推荐.' union all
select '59ef004de33b29e9',13234352525,'枣完全是很脏很脏的那种,洗都洗不干净' union all
select '5d8c4f276b01406a',12790821726,'很不错,送人了,嘻嘻!!' union all
select 'c0ae545630d749e9',13234352525,'这个吃得最快了.一斤几下吃完了.' union all
select 'c20487f00c7749e9',13234352525,'最爱的了,个头大,肉厚,核小,简直是枣中的极品啊!' union all
select 'c4a437e84cf7c9e9',13234352525,'很好吃,个大,还很甜' union all
select 'c61aab262e4f49e9',13234352525,'个头好大啊' union all
select 'c64c5f4a52a7c9e9',13234352525,'很好的大枣啊,买了n次了,还有客服很和蔼可亲啊' union all
select 'c7e5e08dc1ed49e9',13234352525,'枣好空,不饱满,不好吃' union all
select 'c8c6d4b047749e9',13234352525,'质量不错,有机会再来' union all
select 'cc977f32cc9069e9',13234352525,'枣子很甜,我推荐' union all
select 'ce1f1bdc4faf49e9',13234352525,'枣子很脏,不像是新枣,里面有坏的,不过个头挺大' union all
select 'd03e3f052b549e9',13234352525,'大枣真的很大,还很甜,真的很赞,已经买第二次了' union all
select 'd08dab575c3749e9',13234352525,'好评!经常来这里买东西挺不错的、' union all
select 'd25ffbd81c7925e9',13234352525,'好吃 下次还来' union all
select 'd2a2f0c2167749e9',13234352525,'很不错的商家很给力的商品!~亲们我们一定会在合作的的哦!~~掌柜的人超级好嘻嘻' union all
select 'd3ee14a83bf749e9',13234352525,'好大一粒,抵,快递很给力' union all
select 'd7f85fdca01125e9',13234352525,'不错哦' union all
select 'd945aad086ff49e9',13234352525,'补血的,卖给妈妈吃的,一日三颗枣....下一句你知道吧.' union all
select 'd9defacfd5f749e9',13234352525,'一般吧' union all
select 'dbfc443c2adc79e9',13234352525,'枣很甜,肉厚,很好吃.' union all
select 'df4b7f733ccec9e9',13234352525,'很快,东西很好,推荐给同事了,下次还回来' union all
select 'e07da4ae6e4fa9e9',13234352525,'真是个大啊!~而且肉厚味甜!妈妈吃了赞不绝口!~下次还来买!!' union all
select 'e1e0aad5a3a3c9e9',13234352525,'先打款期待中' union all
select 'e5640a39fdb749e9',13234352525,'很实惠的好吃!~掌柜的家的东西一如既往的好的哦!~五分好评!~' union all
select 'e67130f8afb349e9',13234352525,'新疆的就是好' union all
select 'e8d772c372ce89e9',13234352525,'很好!' union all
select 'ef87fbcb6bf749e9',13234352525,'帮朋友买的,说枣子有点脏,不干净,要洗了才吃' union all
select 'f06a8e3f7a5e59e9',13234352525,'枣的个儿挺大的,吃了几颗,糯糯的,甜甜的,皮比较薄,肉还挺多的,籽也比较小,下次还来这边买,掌柜的可要给我便宜点呀' union all
select 'f1ef4ee8c3a7c9e9',13234352525,'不错的枣子,个头大,肉厚实.' union all
select 'f9c97a99747749e9',13234352525,'枣不错,挺大的,肉厚,也很甜,全五分.' union all
select 'fa31272ebbb6fbe9',13234352525,'个好大,有点麻烦啊,得洗了再吃' union all
select 'faa8e61ccf01c9e9',13234352525,'评价方未及时做出评价,系统默认好评!' union all
select 'fb40b553791fd0e9',13234352525,'就是好脏啊' union all
select 'fb4f093c1c9629e9',13234352525,'好枣,核小肉多,口感好,喜欢吃.补血养气佳品,常吃益处多,生吃,泡茶,炖汤都可以.吃完再来买.很好的店家,一次买了好多样,发货快,包装细.全5分!' union all
select 'fc6123e60aa349e9',13234352525,'枣的品质不怎么样' union all
select 'fcde31376d9879e9',13234352525,'很不错啊' union all
select 'fe05e0a169c269e9',13234352525,'红枣很好吃额,营养'
select top 3 uuid,goodsid,evaluate from(
select ROW_NUMBER()over(partition by goodsid order by newid()) as id,* from tbl)a
order by id
/*
uuid goodsid evaluate
59ef004de33b29e9 13234352525 枣完全是很脏很脏的那种,洗都洗不干净
5d8c4f276b01406a 12790821726 很不错,送人了,嘻嘻!!
2cd5ea72d9408cef 13379084522 肉有点枯了.
*/
select top 6 uuid,goodsid,evaluate from(
select ROW_NUMBER()over(partition by goodsid order by newid()) as id,* from tbl)a
order by id
/*
uuid goodsid evaluate
fc6123e60aa349e9 13234352525 枣的品质不怎么样
5d8c4f276b01406a 12790821726 很不错,送人了,嘻嘻!!
2cd5ea72d9408cef 13379084522 肉有点枯了.
cc977f32cc9069e9 13234352525 枣子很甜,我推荐
2862d48057e949e9 13234352525 很不错.
42abd9efed8bc8e9 13234352525 枣子个头很大,不错
*/
--更正一下,这下应该可以了
select top 3 uuid,goodsid,evaluate from(
select ROW_NUMBER()over(partition by goodsid order by rand()) as id,* from tbl)a
order by id
/*
uuid goodsid evaluate
c0ae545630d749e9 13234352525 这个吃得最快了.一斤几下吃完了.
5d8c4f276b01406a 12790821726 很不错,送人了,嘻嘻!!
2cd5ea72d9408cef 13379084522 肉有点枯了.
*/
select top 6 uuid,goodsid,evaluate from(
select ROW_NUMBER()over(partition by goodsid order by rand()) as id,* from tbl)a
order by id
/*
uuid goodsid evaluate
c0ae545630d749e9 13234352525 这个吃得最快了.一斤几下吃完了.
5d8c4f276b01406a 12790821726 很不错,送人了,嘻嘻!!
2cd5ea72d9408cef 13379084522 肉有点枯了.
c20487f00c7749e9 13234352525 最爱的了,个头大,肉厚,核小,简直是枣中的极品啊!
c4a437e84cf7c9e9 13234352525 很好吃,个大,还很甜
c61aab262e4f49e9 13234352525 个头好大啊
*/
select distinct goodsid from tbl
/*
goodsid
12790821726
13234352525
13379084522
*/
--貌似只有三个不同的goodsid?
select top 10 ROW_NUMBER() over (partition by goodsid order by RAND())rn, uuid, goodsid, evaluate
from tb
order by NEWID()
--不知道是不是你想要的
select top 4 r=row_number() over (partition by goodsid order by rand()), uuid, goodsid, evaluate
from tb
order by r asc