This sound like you need to use a "group by" or a "where" clause, rather than a distinct. However you could do this using a sub select or a temp table.
-----Original Message----- From: Lewis Billingsley [mailto:[email protected]] Sent: Saturday, September 05, 2009 4:49 PM To: sql Subject: Single Column DISTINCT in Multiple Column SELECT Hello, I've been searching for a way in SQL to make one column distinct when more than one column is listed in the SELECT statement in Oracle. I've seen solutions on the Internet, but none are for Oracle (if in fact the one's I saw actuallly work). Is it possible to do this with Oracle? Thanks Much, Lewis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3243 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
