6 Apr 07:52
select only one column, not the whole record
From: Daniel Fetchinson <fetchinson <at> googlemail.com>
Subject: select only one column, not the whole record
Newsgroups: gmane.comp.python.sqlobject
Date: 2008-04-06 05:55:40 GMT
Subject: select only one column, not the whole record
Newsgroups: gmane.comp.python.sqlobject
Date: 2008-04-06 05:55:40 GMT
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
RSS Feed