Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-16 : 09:13:10
|
| PRASHANT writes "IS IT POSSIBLE TO WRITE A SINGLE QUERY TO DELETE DUPLICATE DATA FROM THE TABLE?I HAVE A TABLE NAMED A1 WITH ONLY ONE COLUMN COL1THE VALUES IN THE COLUMN COL1 ARECOL1AAABBBBBCCDI NEED THE THE TABLE COMPOSION IS CHANGED TO COL1ABCDIS IT POSSIBLE TO DO IT IN ONE QUERY" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-08-16 : 09:13:10
|
| Good golly! Maybe we can write a single query to turn off your CAPS LOCK :) Did you read our article on deleting duplicates (http://www.sqlteam.com/item.asp?ItemID=3331)? |
 |
|
|
|
|
|
INTERESTING QUERY.