[Postgres] Conditionally Select out Filtered Data with SQL Where

SQL gives us the power to choose what data we pull out of our table. We will use the where clause within our select statement with many operators. These include the greater than, less than, equal, and not equal. We will also use some special operators such as "in", "between", and "is".

 

not equal:

$ postgres=# select * from Users where create_date <> '2018-05-05';

 

is:

$ postgres=# select * from Users where first_name is null;
  create_date |             user_handle              | last_name | first _name
--------------+--------------------------------------+-----------+-------------
  2018-08-06  | fw1kv3z4-fk98-pl2f-se48-f823jfhaj39f |           |
  (1 row )

If you use =

$ postgres=# select * from Users where first_name = null;
  create_date |             user_handle              | last_name | first _name
--------------+--------------------------------------+-----------+-------------
  (0 rows )
$ postgres=#

 

between:

$ postgres=# select * from Users where create_date between '2018-05-01' and '2018-07-01';
  create_date |             user_handle              | last_name | first _name
--------------+--------------------------------------+-----------+-------------
  2018-06-06  | 2839f831-f82c-faj3-aof3-fj28ddks39ek | clark     | tyler
  2018-06-06  | 6ab3b2d2-8e02-890c-bb6d-61a67cd43f31 | jones     | debbie
  (2 rows )
$ postgres=#

 

in:

$ postgres=# select * from Users where last_name in ('clark', 'jones');
  create_date |             user_handle              | last_name | first _name
--------------+--------------------------------------+-----------+-------------
  2018-06-06  | 2839f831-f82c-faj3-aof3-fj28ddks39ek | clark     | tyler
  2018-06-06  | 6ab3b2d2-8e02-890c-bb6d-61a67cd43f31 | jones     | debbie
  (2 rows )
$ postgres=#

 

posted @   Zhentiw  阅读(141)  评论(0编辑  收藏  举报
编辑推荐:
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· AI技术革命,工作效率10个最佳AI工具
历史上的今天:
2019-09-02 [Functional Programming] Rewrite a reducer with functional state ADT
2019-09-02 [Angular] Using Pipe for function memoization
2018-09-02 [Spring] Properties for project configuration
2018-09-02 [Spring] Bean Scope Singleton cs Prototype
2017-09-02 [React] Remove React PropTypes by using Flow Annotations (in CRA)
2016-09-02 [Ramda] Compose and Curry
2015-09-02 [React] React Fundamentals: with-addons - ReactLink
点击右上角即可分享
微信分享提示