Hi folks, Is it possible to select only 1 column out of a table and not the whole record? More specifically, what I really need is the following:
SELECT DISTINCT column FROM table; The point is that I only need DISTINCT values and if I can't select 1 column only then I can't use DISTINCT because generally full records are never the same but the value in 'column' might be repeated. So I would need to select everything and filter through the data in python which would be a huge performance hit. Cheers, Daniel ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss