[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=#
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 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