nulls first 或 nulls last

最新推荐文章于 2022-08-19 23:10:06 发布

majinbo111

最新推荐文章于 2022-08-19 23:10:06 发布

阅读量364

点赞数

分类专栏： postgreSQL 文章标签： nulls first nulls last

本文链接：https://blog.csdn.net/u011944141/article/details/82119048

版权

postgreSQL 专栏收录该内容

64 篇文章 7 订阅

订阅专栏

#原数据
select * from jinbo.tel_info;
 person |    day     | recevice | miss 
--------+------------+----------+------
 A      | 2018-01-18 |       10 |    0
 B      | 2018-01-18 |        0 |    5
 C      | 2018-01-18 |        4 |    4
 D      | 2018-01-18 |        0 |    0
 E      | 2018-08-27 |        2 |     
(5 rows)

# asc 的时候默认把null 后排， 相当于 order by miss asc nulls last 
select * from jinbo.tel_info order by miss asc;
 person |    day     | recevice | miss 
--------+------------+----------+------
 A      | 2018-01-18 |       10 |    0
 D      | 2018-01-18 |        0 |    0
 C      | 2018-01-18 |        4 |    4
 B      | 2018-01-18 |        0 |    5
 E      | 2018-08-27 |        2 |     
(5 rows)

# asc nulls first
select * from jinbo.tel_info order by miss asc nulls first;
 person |    day     | recevice | miss 
--------+------------+----------+------
 E      | 2018-08-27 |        2 |     
 A      | 2018-01-18 |       10 |    0
 D      | 2018-01-18 |        0 |    0
 C      | 2018-01-18 |        4 |    4
 B      | 2018-01-18 |        0 |    5
(5 rows)

#asc 的时候默认把null 前排， 相当于 order by miss asc nulls first 
select * from jinbo.tel_info order by miss desc;
 person |    day     | recevice | miss 
--------+------------+----------+------
 E      | 2018-08-27 |        2 |     
 B      | 2018-01-18 |        0 |    5
 C      | 2018-01-18 |        4 |    4
 A      | 2018-01-18 |       10 |    0
 D      | 2018-01-18 |        0 |    0


#desc nulls last
select * from jinbo.tel_info order by miss desc nulls last;
 person |    day     | recevice | miss 
--------+------------+----------+------
 B      | 2018-01-18 |        0 |    5
 C      | 2018-01-18 |        4 |    4
 A      | 2018-01-18 |       10 |    0
 D      | 2018-01-18 |        0 |    0
 E      | 2018-08-27 |        2 |     
(5 rows)