更新时间: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