[T-SQL] Remove Duplicates from a Table using specific columns |
| Remove Duplicates from a Table using specific columns Posted: 23 Mar 2013 03:44 PM PDT Hi Gurus,I am new to Teradata and working on a requirement.Below is the tableCol1 Col2 Col3 Col4A Y 1 ZB Y 2 QC Y 3 RA Y 4 ZA Y 5 ZOutput as:Col1 Col2 Col3 Col4A Y 1 ZB Y 2 QC Y 3 RPlease guide me resolving this issue.Thanks,LG |
| Posted: 23 Mar 2013 01:13 PM PDT HiI am struggling to find out how can I do the following in my SP.[quote]UPDATE EmployeeDataSET[b]selected = (NOT selected)[/b]WHERE SeqNo = 116[/quote]I want to switch this value in BIT coloumn to the oppositeTIA |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment