Postgresql

SQL Data Types: Oracle, SQL Server, MySQL, PostgreSQL

Jan 11, 2020 · 16 min read · mysql oracle postgresql sql-server ·

Do you want to know what the SQL data types are in different database vendors? Learn all about them and how they compare in this guide.

SQL Comments: A How-To Guide

Jan 9, 2020 · 7 min read · mysql oracle postgresql sql-server ·

Share on:

Many programming languages allow you to comment out code so that it does not run. SQL allows comments as well. Learn how to add SQL comments in this article.

SQL ALTER TABLE: A Complete Guide

Jan 7, 2020 · 10 min read · mysql oracle postgresql sql-server ·

Share on:

Learn all about the SQL Alter Table statement.

SQL COUNT Function Explained with Examples

Jan 5, 2020 · 7 min read · mysql oracle postgresql sql-functions sql-server ·

Share on:

The SQL COUNT function is one of the most common functions used by SQL developers. I use it on a daily basis. Learn more about the COUNT function in this article.

SQL DROP TABLE: The Complete Guide

Jan 5, 2020 · 6 min read · mysql oracle postgresql sql-server ·

Share on:

Learn how to drop tables in SQL.

SQL CASE Statement Explained with Examples

Jan 4, 2020 · 12 min read · mysql oracle postgresql sql-functions sql-server ·

Share on:

The SQL CASE statement allows you to perform IF-THEN-ELSE functionality within an SQL statement. Learn more about this powerful statement in this article.