SQL SELECT DISTINCT: Performance Best Practices
Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say...
SQL OR Statement: The Basics
Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create,...
How to Use SQL SUM Function
SQL is a powerful and widely-used programming language for data storage, retrieval, and manipulation. One of the most commonly-used...
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of....
SQL BETWEEN-Smart Tips to Scan for a Range of Values
SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be inclusive or within the range. Or it can be...
SQL Server ORDER BY Clause: The 5 Do’s and Don’ts to Sort Data Like a Pro
Ugly. That’s what unsorted data looks like. We make data easy for the eyes by sorting them. And that’s what SQL ORDER BY is for. Use...
Overview of T-SQL PRINT Statement
PRINT statements are crucial in any programming language. They will allow the routine or program...
GROUP BY in SQL Server: 3 Easy Examples to Group Results
Grouping is an important feature that helps organize and arrange data. There are a lot of ways to do it, and one of the most effective...
How to Comment MySQL Code: Best Practices
Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when...
How to Use a ROUND Function in SQL Server
The ROUND function in SQL Server is a powerful tool that allows you to round numeric values to a...
