且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在sql中使用distinct

更新时间:2023-01-28 17:52:32

你不想要DISTINCT - 你想使用子查询:

SELECT Image_id,Tit le,Image_path FROM
SELECT *,ROW_NUMBER() OVER PARTITION BY 标题 ORDER Image_Id) AS rn FROM MyTable)x
WHERE rn = 1


Table:

image_id	Title	image_path	
1	Test	../UploadedImage/images (4).jpg
2	rose	../UploadedImage/Hydrangeas.jpg	
3	Test	../UploadedImage/Desert.jpg	
4	rose	../UploadedImage/download (1).jpg	


How do i get Result like below

 Title      image_path
Test ../UploadedImage/images (4).jpg
 rose    ../UploadedImage/Hydrangeas.jpg


I wanna select distinct by Title ,But Same title have multilple Images
select Top 1 Records
any body help me?

You don't want DISTINCT - you want to use a subquery:
SELECT Image_id, Title, Image_path FROM
       (SELECT  *, ROW_NUMBER() OVER (PARTITION BY Title ORDER By Image_Id ) AS rn FROM MyTable) x
WHERE rn = 1