Get unique data among multiple items

Question

please see the image ..in that i want only that marked data.please tell me the query please..thanks in advance...

Amit Gupta · Answer

Hey SreeRam As you have mentioned to get unique data and simultaneously you are asking to get only selected data (as in image). If you want to get unique data you can use Select distinct columnName from tableName And if you want to select items within the range then go for the salman's reply

Abhinav Abhishek · Answer

select TOP 1 * from dbo.tbl_Image Where AlbumName = 'IE' UNION select TOP 1 * from dbo.tbl_Image Where AlbumName = 'New Album'

Bikesh Srivastava · Answer

as per your query i think Abhinav is you are sying correct just write query with where clause. But best way you can use group by for each collection and get top 1.

Salman · Answer

use like this select * from dbo.tbl_Image Where ImgInfo in('~/uploads/IE/image-slider-1.jpg''~/uploads/New Album/download(4).jpg'); thanks.