Sooraj S Sooraj S - 1 year ago 131
SQL Question

select sql distinct

I have more than one image with the id 83, 84... I want to select only one image from id 83, 84... using sql `distinct.

Screenshot of data

Answer Source

Try your query like this

select * from images group by jy_id

or you can try:-

select distinct jy_id, jy_tour_book_picture from images group by jy_id
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download