Allvendors

How to Escape Single Quotes in SQL

May 1, 2017 · 4 min read · sql ·

Share on:

Do you need to escape special characters or escape a single quote in SQL? Learn how to do that in this article.

The Difference Between WHERE and HAVING Clause

Mar 13, 2017 · 4 min read · sql ·

Share on:

What is the difference between WHERE and HAVING clause in SQL? Learn what they are and the differences in this article.

What Does SQL PARTITION BY Do?

Aug 29, 2016 · 4 min read · sql ·

Share on:

Have you ever seen the PARTITION BY keyword used in SQL queries? If so, do you know what it does and how to use it? Learn about the SQL PARTITION BY keyword and see some examples in this article.

SQL RANK and DENSE_RANK: Function Guide, FAQ, and Examples

Nov 12, 2015 · 11 min read · sql-functions ·

Share on:

In this article, you'll learn everything about the SQL RANK and DENSE_RANK functions that are available in Oracle, SQL Server, MySQL, and Postgres.

SQL NULLIF Function Explained with Examples

Jun 18, 2015 · 5 min read · sql-functions ·

Share on:

The SQL NULLIF function is available in many vendors. Let's take a look at what NULLIF does and what you can use it for.

SQL COALESCE Function Usage, Tips & Examples

Apr 16, 2015 · 8 min read · sql-functions ·

Share on:

Learn about the SQL COALESCE function in this guide.

SQL ROUND Function with Examples

Apr 2, 2015 · 6 min read · sql-functions ·

Share on:

The SQL ROUND function allows you to round a number to a specific number of decimal places. Let's see how it works and see some examples.