Skip to content
Miscellaneous
Sorting: Two sorting conditions
First number
Second number
Expected order
First number
Second number
Expected order
1
0
40
1
2
0
3000
2
3
0.9989
0
3
4
0.999
0
4
5
1
2
5
6
1
5
6
7
1
30
7
8
2
0
8
9
14.8919
1
9
10
148918
2
10
11
1489187664
7
11
There are no rows in this table
Sorting: Numbers turned into quadruple unicode
First number
Second number
Quadruple unicode "list"
Expected order
First number
Second number
Quadruple unicode "list"
Expected order
1
0
40
丠丠丠丠 丠丠临丠
1
2
0
3000
丠丠丠丠 丠丠叼丠
2
3
0.9989
0
丠丠丠甥 丠丠丠丠
3
4
0.999
0
丠丠丠甦 丠丠丠丠
4
5
1
2
丠丠丠田 丠丠両丠
5
6
1
5
丠丠丠田 丠丠丢田
6
7
1
30
丠丠丠田 丠丠丯丠
7
8
2
0
丠丠両丠 丠丠丠丠
8
9
14.8919
1
丠丠丧烷 丠丠丠田
9
10
148918
2
丠丣蚛丠 丠丠両丠
10
11
1489187664
7
両酭萨丠 丠丠丣田
11
There are no rows in this table
Sorting: Numbers combined into a string
First number
Second number
Combined string
Expected order
First number
Second number
Combined string
Expected order
1
0
40
0 40
1
2
0
3000
0 3000
2
3
0.999
0
0.999 0
4
4
0.9989
0
0.9989 0
3
5
1
2
1 2
5
6
1
5
1 5
6
7
1
30
1 30
7
8
2
0
2 0
8
9
14.8919
1
14.8919 1
9
10
148918
2
148918 2
10
11
1489187664
7
1489187664 7
11
There are no rows in this table
Sorting: Numbers concatenated into a string
First number
Second number
Concatenated string
Expected order
First number
Second number
Concatenated string
Expected order
1
0
40
0 40
1
2
0
3000
0 3000
2
3
0.999
0
0.999 0
4
4
0.9989
0
0.9989 0
3
5
1
2
1 2
5
6
1
5
1 5
6
7
1
30
1 30
7
8
2
0
2 0
8
9
14.8919
1
14.8919 1
9
10
148918
2
148918 2
10
11
1489187664
7
1489187664 7
11
There are no rows in this table
Sorting: Numbers combined into a list
First number
Second number
Combined list
Expected order
First number
Second number
Combined list
Expected order
1
0
40
040
1
2
0
3000
03000
2
3
0.999
0
0.9990
4
4
0.9989
0
0.99890
3
5
1
2
12
5
6
1
5
15
6
7
1
30
130
7
8
2
0
20
8
9
14.8919
1
14.89191
9
10
148918
2
1489182
10
11
1489187664
7
14891876647
11
There are no rows in this table
Sorting: Numbers combined into an object
First number
Second number
Combined object
Expected order
First number
Second number
Combined object
Expected order
1
0
40
1
2
0
3000
2
3
0.999
0
0.999
4
4
0.9989
0
0.9989
3
5
1
2
1
5
6
1
5
1
6
7
1
30
1
7
8
2
0
2
8
9
14.8919
1
14.8919
9
10
148918
2
148918
10
11
1489187664
7
1489187664
11
There are no rows in this table
Sorting: Numbers combined into a json array
First number
Second number
Json array
Expected order
First number
Second number
Json array
Expected order
1
0
40
040
1
2
0
3000
03000
2
3
0.999
0
0.9990
4
4
0.9989
0
0.99890
3
5
1
2
12
5
6
1
5
15
6
7
1
30
130
7
8
2
0
20
8
9
14.8919
1
14.89191
9
10
148918
2
1489182
10
11
1489187664
7
14891876647
11
There are no rows in this table
Sorting: Numbers turned into concatenated objects
First number
Second number
Concatenated objects
Expected order
First number
Second number
Concatenated objects
Expected order
1
0.999
0
0.999
4
2
0.9989
0
0.9989
3
3
0
40
40
1
4
0
3000
3000
2
5
1
2
1
2
5
6
1
5
1
5
6
7
1
30
1
30
7
8
2
0
2
8
9
14.8919
1
14.8919
1
9
10
148918
2
148918
2
10
11
1489187664
7
1489187664
7
11
There are no rows in this table
Sorting: Numbers turned into unicode characters
First number
Second number
Unicode "list"
Expected order
First number
Second number
Unicode "list"
Expected order
1
0.9989
0
3
2
0.999
0
4
3
1
2
5
4
1
30
7
5
1
5
6
6
14.8919
1
9
7
2
0
8
8
0
40
)
1
9
0
3000
ஹ
2
10
1489187664
7
㍑
11
11
148918
2
䖷
10
There are no rows in this table
Sorting: Numbers turned into far unicode characters
First number
Second number
Far unicode "list"
Expected order
First number
Second number
Far unicode "list"
Expected order
1
0.9989
0
丠丠
3
2
0.999
0
丠丠
4
3
0
40
丠么
1
4
0
3000
丠姘
2
5
1
2
両丢
5
6
1
5
両严
6
7
1
30
両举
7
8
2
0
丢丠
8
9
14.8919
1
丮両
9
10
1489187664
7
腰丧
11
11
148918
2
鏖丢
10
There are no rows in this table
Sorting: Numbers turned into far unicode characters + Rank()
First number
Second number
Far unicode "list" + Rank()
Expected order
First number
Second number
Far unicode "list" + Rank()
Expected order
1
0
40
両个
1
2
0
3000
両丫
2
3
0.9989
0
丣両
3
4
0.999
0
两両
4
5
1
2
严严
5
6
1
5
严丧
6
7
1
30
严丩
7
8
2
0
丨両
8
9
14.8919
1
丩两
9
10
148918
2
个严
10
11
1489187664
7
丫丨
11
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.