SELECT TOP 1
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 15, 2003 4:02 PM Subject: OT: SQL first row of duplicates problem > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
