NAME ------------- sumansuman nehaneha anjalianjali
我想这样输出:
NAME ------------- suman neha anjali
SELECT LEFT(name,LEN(name)/2) FROM temp
要捕获不是这种情况的行:
SELECT name FROM temp WHERE NOT name = LEFT(name,LEN(name)/2) + LEFT(name,LEN(name)/2)