Hi list, I have an SQL-problem 29 [EMAIL PROTECTED] Mister Mayer 2 26 [EMAIL PROTECTED] Mister Mayer 2 4 [EMAIL PROTECTED] Misses Miller 2
I want to mark every first (but only the first !) line of the lines where the email adress is equal. e.g. with ID = 29 (see above) How can I do this ? SELECT email FROM user GROUP BY Email HAVING Count(*) > 1 Gives me the email-record but I am not sure how to mark the FIRST duplicate row. Ideas ? Thanks ! Uwe ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
