Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 4236 invoked from network); 5 May 2004 01:20:02 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 5 May 2004 01:20:02 -0000 Received: (qmail 48747 invoked by uid 500); 5 May 2004 01:19:42 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 48724 invoked by uid 500); 5 May 2004 01:19:42 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 48703 invoked from network); 5 May 2004 01:19:41 -0000 Received: from unknown (HELO spitfire.ecc.engr.uky.edu) (128.163.144.21) by daedalus.apache.org with SMTP; 5 May 2004 01:19:41 -0000 Received: from www by spitfire.ecc.engr.uky.edu with local (Exim 4.30) id 1BLB4g-000HfY-IT for torque-user@db.apache.org; Tue, 04 May 2004 21:19:50 -0400 Received: from squeeze.csr.uky.edu (squeeze.csr.uky.edu [204.198.74.33]) by mail.engr.uky.edu (IMP) with HTTP for ; Tue, 4 May 2004 21:19:50 -0400 Message-ID: <1083719990.4098413682146@mail.engr.uky.edu> Date: Tue, 4 May 2004 21:19:50 -0400 From: Saravana Kannan To: Apache Torque Users List Subject: Retrieving unique values of a field. MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 204.198.74.33 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi, I have a table with a VARCHAR field. I want to extract all the unique values in the table for that field. AFAIK torque only reads in whole records as objects. Is there a way to get only a particular file. I want something like - SELECT UNIQUE(category) FROM tablex; ~Sarav -- There are 10 kinds of people in the world, those who know binary and those who don't. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org