On 19 October 2010 16:26, jeff archer <jarch...@yahoo.com> wrote: > I have a table containing width and height of images with columns wPixels, > hPixels. I would like to select all rows that have either a unique wPixels > or a > unique hPixels value. > > for this data: > 10, 20 > 10, 20 > 10, 30 > 10, 3015, 10 > 15, 30 > 15, 30 > 15, 30 > > I would like to select: > 10, 20 > 10, 30 > 15, 10 > 15, 30
select distinct wPixels, hPixels from table; > > Jeff Archer Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users