Thanks for the tip, will try that. RBS
-----Original Message----- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: 15 February 2007 22:27 To: [email protected] Subject: RE: [sqlite] SELECT DISTINCT but ignore one column? You could do this with a group by and use a min or max aggregate function on the "ignored" column HTH, Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2007 4:37 PM To: [email protected] Subject: [sqlite] SELECT DISTINCT but ignore one column? It sometimes would be very useful if you could do a SELECT DISTINCT, but ignoring the data in one (or maybe more) particular column. So for example col1 col2 col3 ----------------- A B C A D C Then doing SELECT DISTINCT (IGNORE col2) * from table would produce: A B C It wouldn't matter for me if it produced the above or A D C But there could be rules/logic to that. Is this possible in SQLite or would it be possible to add this as a new option? RBS ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
