Tag: sql functions

How to Get SQL Percentage Calculation as Easy as Pie 

SQL Server, Work with data

Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a...
Read More

SQL Aggregate Functions: Easy Tips for Newbies

Database development, Statements

SQL Aggregate Functions are functions that perform calculations and return a summarized result. With these, it’s easy to do these...
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

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...
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 it’s good and add DISTINCT when...
Read More

Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases

Database administration, Security

There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what...
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...
Read More

User-Defined Functions in SQL Server

Database administration, Database Optimization & Structure, SQL Server, Statements

User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many...
Read More

SQL Server ORDER BY Clause: The 5 Do’s and Don’ts to Sort Data Like a Pro

Database development, Statements

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...
Read More

GROUP BY in SQL Server: 3 Easy Examples to Group Results

Database development, SQL Server, Statements

Grouping is an important feature that helps organize and arrange data. There are a lot of ways to...
Read More
Close