testData = table(1 2 3 4 5 6 7 8 9 10 asid,1 2 3 4 5 6 7 8 9 10 as
val)
将val列分成2组:value <= 5,5
给你:
testData = table(1 2 3 4 5 6 7 8 9 10 as id,1 2 3 4 5 6 7 8 9 10 as val)
select sum(val) from testData group by val <= 5