Hi, It happens often that I'd need to have a DISTINCT clause applied to some columns only, instead of the whole row. Example: I have a request of rejected messages with a date-time column and the addess in another one. Sometimes, the sever attempted to send the messages many times to the same address. I'm not interest of having the time for every attempts, only the first one. Ex: SELECT DISTINCT errorTime, address, errorMess What I need who be kind of: SELECT DISTINCT(address, errorMess) errorTime, address, errorMess
Any idea on how to do this in plain SQL ? (The database is Access) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3370 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
