<\/span><\/h2>\n\n\n\n\u8bf7\u5173\u6ce8\u91cc\u9762\u7684values \u4e3a 888\u7684\u6570\u636e\u3002\u67092\u884c\u3002<\/p>\n\n\n\n
gbase> select * from t1;\n+------+--------+---------------------+\n| id | value | birth |\n+------+--------+---------------------+\n| 1 | 234 | NULL |\n| 2 | 567 | NULL |\n| 3 | 888 | NULL |<\/span>\n| 4 | 999 | NULL |\n| 5 | 555555 | 2020-01-03 00:00:00 |\n| 4 | 888 | 2021-04-13 00:00:00 |<\/span>\n+------+--------+---------------------+\n6 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u5f00\u7a97\u67e5\u8be2<\/span><\/h2>\n\n\n\n<\/span>\u9ed8\u8ba4\u662fnulls last<\/span><\/h3>\n\n\n\ngbase> select id,value,birth,row_number() over(partition by value order by birth) num from t1;\n+------+--------+---------------------+-----+\n| id | value | birth | num |\n+------+--------+---------------------+-----+\n| 4 | 888 | 2021-04-13 00:00:00 | 1 |\n| 3 | 888 | NULL | 2 |<\/span>\n| 4 | 999 | NULL | 1 |\n| 1 | 234 | NULL | 1 |\n| 2 | 567 | NULL | 1 |\n| 5 | 555555 | 2020-01-03 00:00:00 | 1 |\n+------+--------+---------------------+-----+\n6 rows in set (Elapsed: 00:00:00.10)\n\ngbase> select id,value,birth,row_number() over(partition by value order by birth nulls last) num from t1;\n+------+--------+---------------------+-----+\n| id | value | birth | num |\n+------+--------+---------------------+-----+\n| 4 | 888 | 2021-04-13 00:00:00 | 1 |\n| 3 | 888 | NULL | 2 |<\/span>\n| 4 | 999 | NULL | 1 |\n| 1 | 234 | NULL | 1 |\n| 2 | 567 | NULL | 1 |\n| 5 | 555555 | 2020-01-03 00:00:00 | 1 |\n+------+--------+---------------------+-----+\n6 rows in set (Elapsed: 00:00:00.06)\n\n<\/code><\/pre>\n\n\n\n<\/span>row_number nulls first<\/span><\/h3>\n\n\n\n\u53ef\u4ee5\u770b\u5230 null \u503c\u6392\u5728\u4e86\u6700\u524d\u9762\u4e86\u3002<\/p>\n\n\n\n
gbase> select id,value,birth,row_number() over(partition by value order by birth nulls first) num from t1;\n+------+--------+---------------------+-----+\n| id | value | birth | num |\n+------+--------+---------------------+-----+\n| 3 | 888 | NULL | 1 |\n| 4 | 888 | 2021-04-13 00:00:00 | 2 |<\/span>\n| 4 | 999 | NULL | 1 |\n| 1 | 234 | NULL | 1 |\n| 2 | 567 | NULL | 1 |\n| 5 | 555555 | 2020-01-03 00:00:00 | 1 |\n+------+--------+---------------------+-----+\n6 rows in set (Elapsed: 00:00:00.07)\n<\/code><\/pre>\n\n\n\n<\/span>rank nulls first<\/span><\/h3>\n\n\n\ngbase> select id,value,birth,rank() over(partition by value order by birth nulls first) num from t1;\n+------+--------+---------------------+-----+\n| id | value | birth | num |\n+------+--------+---------------------+-----+\n| 3 | 888 | NULL | 1 |\n| 4 | 888 | 2021-04-13 00:00:00 | 2 |<\/span>\n| 4 | 999 | NULL | 1 |\n| 1 | 234 | NULL | 1 |\n| 2 | 567 | NULL | 1 |\n| 5 | 555555 | 2020-01-03 00:00:00 | 1 |\n+------+--------+---------------------+-----+\n6 rows in set (Elapsed: 00:00:00.11)\n<\/code><\/pre>\n\n\n\n<\/span>\u666e\u901a\u6392\u5e8f<\/span><\/h2>\n\n\n\n<\/span>\u6570\u636e<\/span><\/h3>\n\n\n\n\u5176\u4e2did=10\u67092\u884c\uff0cname\u6709\u4e00\u4e2a\u6570\u503c\u4e3anull\u3002<\/p>\n\n\n\n
gbase> select * from t1;\r\n+------+--------------+\r\n| id | name |\r\n+------+--------------+\r\n| 10 | 10101010 |<\/span>\r\n| 100 | 100100100100 |\r\n| 10 | NULL |<\/span>\r\n| 1 | 1111 |\r\n+------+--------------+\r\n4 rows in set (Elapsed: 00:00:00.01)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u5355\u5217\u6392\u5e8f\uff08NULL\u5217)<\/span><\/h3>\n\n\n\n\u7ed3\u679c\u548c\u9884\u671f\u76f8\u7b26\uff0c\u9ed8\u8ba4\u662fnull last\u3002<\/p>\n\n\n\n
gbase> select * from t1 order by name;\r\n+------+--------------+\r\n| id | name |\r\n+------+--------------+\r\n| 100 | 100100100100 |\r\n| 10 | 10101010 |\r\n| 1 | 1111 |\r\n| 10 | NULL |<\/span>\r\n+------+--------------+\r\n4 rows in set (Elapsed: 00:00:00.03)\r\n\r\ngbase> select * from t1 order by name nulls first;\r\n+------+--------------+\r\n| id | name |\r\n+------+--------------+\r\n| 10 | NULL |<\/span>\r\n| 100 | 100100100100 |\r\n| 10 | 10101010 |\r\n| 1 | 1111 |\r\n+------+--------------+\r\n4 rows in set (Elapsed: 00:00:00.03)\r\n\r\ngbase> select * from t1 order by name nulls last;\r\n+------+--------------+\r\n| id | name |\r\n+------+--------------+\r\n| 100 | 100100100100 |\r\n| 10 | 10101010 |\r\n| 1 | 1111 |\r\n| 10 | NULL |<\/span>\r\n+------+--------------+\r\n4 rows in set (Elapsed: 00:00:00.04)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u591a\u5217\u6392\u5e8f\uff08NULL\u5217\u9760\u540e)<\/span><\/h3>\n\n\n\n\u548c\u9884\u671f\u76f8\u7b26\u3002<\/p>\n\n\n\n
gbase> select * from t1 order by id,name;\r\n+------+--------------+\r\n| id | name |\r\n+------+--------------+\r\n| 1 | 1111 |\r\n| 10 | 10101010 |\r\n| 10 | NULL |<\/span>\r\n| 100 | 100100100100 |\r\n+------+--------------+\r\n4 rows in set (Elapsed: 00:00:00.03)\r\n\r\ngbase> select * from t1 order by id,name nulls first;\r\n+------+--------------+\r\n| id | name |\r\n+------+--------------+\r\n| 1 | 1111 |\r\n| 10 | NULL |\r\n| 10 | 10101010 |<\/span>\r\n| 100 | 100100100100 |\r\n+------+--------------+\r\n4 rows in set (Elapsed: 00:00:00.02)\r\n\r\ngbase> select * from t1 order by id,name nulls last;\r\n+------+--------------+\r\n| id | name |\r\n+------+--------------+\r\n| 1 | 1111 |\r\n| 10 | 10101010 |\r\n| 10 | NULL |<\/span>\r\n| 100 | 100100100100 |\r\n+------+--------------+\r\n4 rows in set (Elapsed: 00:00:00.03)\r\n\r\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5728GBase 8a 8.6.2Build43\u7248\u672c\uff0c\u5f00\u59cb\u652f\u6301\u5728\u5f00\u7a97\u51fd\u6570\u548c\u666e\u901a\u6392\u5e8forder \u90e8\u5206\u6307\u5b9anull\u503c\u7684\u4f4d\u7f6e\uff0c\u5305\u62ec nulls first, \u548c nulls last\uff0c\u4e0d\u4e4b\u6307\u5b9a\u65f6\u9ed8\u8ba4\u662fnulls last\u6548\u679c\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[36],"class_list":["post-5323","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-36"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=5323"}],"version-history":[{"count":6,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5323\/revisions"}],"predecessor-version":[{"id":5524,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5323\/revisions\/5524"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=5323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=5323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=5323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}