Statements

Exploring SQL Server LEN() Function

Database development, SQL Server, Statements

SQL Server supports different data types to store relevant data in SQL tables. These data types can...
Read More

SQL Server COUNT Function

Database development, Statements

COUNT is one of the common SQL Server Aggregate operations done by almost all SQL Server Developers for their day-to-day needs. In this...
Read More

SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection

Database development, Statements

Using Structured Query Language (SQL) can seem complicated at first, but further, it will become easier and much more convenient. You only...
Read More

SQL JOINs Tutorial with Examples

Database development, Statements

In this article, we are going to takes a close look at SQL Server JOINs. We will review all...
Read More

Drop Temp Table in SQL Server and PostgreSQL

Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Read More

How to Use SQL Server T-SQL Function SUM: 5 Use Cases

Database development, Statements

The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column –...
Read More

SQL SELECT DISTINCT: Performance Best Practices

Database development, Statements

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say...
Read More

SQL OR Statement: The Basics

Database development, Statements

Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create,...
Read More

How to Use SQL SUM Function

Database development, Statements

SQL is a powerful and widely-used programming language for data storage, retrieval, and manipulation. One of the most commonly-used...
Read More

How to Use REPLACE in SQL

Database development, Statements

When querying data with SQL, the need to manipulate string-based results is very common. There are...
Read More
Close