Hi, I can't figure how to do this in SQL: I have a query: SELECT agName, agURL FROM agents In the table I may have several identical agName with different agURL. What I want is only one record per agName, with whatever agURL, doesn't matter which one, but at least one of them.
If I use SELECT DISTINCT agName, agURL FROM agents I get all identical agName with different agUrl. I would need only the first of each group with the same agName. Is it possible? -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
