Thread: oracle query required
View Single Post
  #2 (permalink)  
Old 08-30-10, 12:25
blindman blindman is offline
World Class Flame Warrior
  
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
PLSQL sucks, doesn't it?

Code:
UPDATE t1
SET t1.H = 'I'
FROM dbo.ABC AS t1
WHERE	t1.A in
	(SELECT MIN(A) AS A
	FROM dbo.ABC
	GROUP BY C
	HAVING COUNT(*) > 1)
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote