FB
SQL COUNT Function Explained with Examples

SQL COUNT Function Explained with Examples

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. This article applies to Oracle, SQL Server, MySQL, and PostgreSQL. Table of Contents Purpose of the SQL... Read more
SQL CASE Statement Explained with Examples

SQL CASE Statement Explained with Examples

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. This article applies to Oracle, SQL Server, MySQL, and PostgreSQL. Table of Contents What Does the SQL CASE... Read more
A Guide to SQL NULL (and SQL NOT NULL)

A Guide to SQL NULL (and SQL NOT NULL)

The concept of NULL is something you should know about when working with databases. In this article, you’ll learn all about NULL: what it is, why it’s different, how you can check for it in different databases, and many examples. What Is NULL? A NULL is... Read more
Oracle Mathematical Functions

Oracle Mathematical Functions

Do you need to use sine, cosine, or tangent functions in your queries or database code? Oracle has plenty of those functions you can use. Learn how to use them and see some examples in this article. What Are The Mathematical Functions? The mathematical functions are... Read more