如何在sql中使用分区 [英] how to use partition in sql

问题描述

我的表：

My Table:

id    img_name	   img	                          cat_id	sub_id
1	blue	 ../UploadedImage/download (1).jpg 1	       2
2	rose	 ../UploadedImage/images (3).jpg   1	       1
5	kola	 ../UploadedImage/6pl.jpg	   2	       3
6	rat	 ../UploadedImage/Hydrangeas.jpg   2	       4
7	animal	 ../UploadedImage/0z8.jpg	   1	       5
9	fdd	 ../UploadedImage/images (2).jpg   1	       1
10	guys	 ../UploadedImage/Desert.jpg	   2	       3
11	ddfdf	 ../UploadedImage/download.jpg	   1	       1
12	ddfdfdfd ../UploadedImage/images (1).jpg   1	       1

我如何得到如下结果

How do i get Result like below

  img_name                                         cat_id           sub_id
    blue    ../UploadedImage/download (1).jpg   1   2
rose    ../UploadedImage/images (3).jpg 1   1       1
ddfdf   ../UploadedImage/download.jpg   1   1       1
ddfdfdfd    ../UploadedImage/images (1).jpg 1   1

我想通过sub_id选择不同，但是相同的sub_id有多个图像

选择前1个记录....



i我正在使用子类别表

任何身体帮我吗？

I wanna select distinct by sub_id,But Same sub_id have multilple Images
select Top 1 Records....

i am using subcategory table
any body help me?

推荐答案

上一个帖子的解决方案：

如何在sql中使用distinct [ ^ ]

Solution from your last thread:
how to use distinct in sql[^]

SELECT Image_id, sub_id, Image_path FROM
       (SELECT  *, ROW_NUMBER() OVER (PARTITION BY sub_id ORDER By Image_Id ) AS rn FROM MyTable) x
WHERE rn = 1

这篇关于如何在sql中使用分区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！