B*****g 发帖数: 34098 | 1 use telnet at work, no chinese input, try below
SELECT DISTINCT IIF(StrConv(TRIM(left(owner, instr(owner,',')-1)), 3) >=
StrConv(TRIM( mid(owner, instr(owner,',')+1)), 3),
StrConv(TRIM(left(owner, instr(owner,',')-1)), 3) & ','
& StrConv(TRIM( mid(owner, instr(owner,',')+1)), 3),
StrConv(TRIM( mid(owner, instr(owner,',')+1)), 3) & ','
& StrConv(TRIM(left(owner, instr(owner,',')-1)), 3)) AS "OWNER"
FROM [table]
提示 |
|
p*****2 发帖数: 21240 | 4 type Any interface{}
type ArrayOps []interface{}
func (arr ArrayOps) Map(lambda func(Any) Any) ArrayOps {
res := make(ArrayOps, len(arr))
for i, v := range arr {
res[i] = lambda(v)
}
return res
}
func main() {
b := ArrayOps{1, 2, 3, 4, 5}.
Map(func(i Any) Any { return strconv.Itoa(i.(int) * 2) })
fmt.Println(b)
} |
|