In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs. SQL Server developers must understand two things: the difference ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

本文分享一些最难以在SQL中学习和执行的具体转换，并提供实际所需的SQL代码。 许多人体验到了云数据仓库内集中计算的速度和效率优势，但同时大家也认识到这种方法存在一些缺点。缺点之一是需要学习和执行不同语言（尤其是SQL）的查询，这增加了很多复杂性 ...

pre-commit is a nice development tool to automatize the binding of pre-commit hooks. After installation and configuration pre-commit will run your hooks before you commit any change. CREATE OR REPLACE ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

从业以来前面的几年主要在做客户端开发，用到的数据库都是表结构比较简单的 SQLite，以我那还给老师一大半的 SQL 水平倒也能对付。现在转岗做后端开发，就显得有点捉襟见肘了，特别是各种 JOIN，有时候傻傻分不清楚，于是索性弄明白并做个记录。 前言 在 ...