sql functions Archives - {coding}Sight

How to Get SQL Percentage Calculation as Easy as Pie

Edwin Sanchez — Thu, 14 Mar 2024 15:54:32 +0000

Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a beginner, it’s easy to get lost in a maze of numbers and functions. You may stumble over pitfalls that can lead to incorrect results. But fear not because we’re about to make SQL percentage calculations as easy as pie! …

The post How to Get SQL Percentage Calculation as Easy as Pie appeared first on {coding}Sight.

SQL Aggregate Functions: Easy Tips for Newbies

Edwin Sanchez — Wed, 28 Sep 2022 07:59:00 +0000

SQL Aggregate Functions are functions that perform calculations and return a summarized result. With these, it’s easy to do these calculations on data sets: But there’s more. Statistical calculations like standard deviation and variance are also part of the tools. Mix it with grouping and sorting, and you’ll have something fantastic for your new report. So, …

The post SQL Aggregate Functions: Easy Tips for Newbies appeared first on {coding}Sight.

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

Philipp Zhenov — Wed, 20 Oct 2021 08:04:10 +0000

Using Structured Query Language (SQL) can seem complicated at first, but further, it will become easier and much more convenient. You only need practice. If you are looking for better ways to manage data in your database or if you are simply curious about the possibilities that SQL opens up to you, then you have …

The post SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection appeared first on {coding}Sight.

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

Manvendra Singh — Wed, 08 Sep 2021 07:43:58 +0000

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 – note that it applies to numeric columns only. Below is the syntax of SQL SUM. ALL is a default value, not mandatory to pass. It allows for returning the sum …

The post How to Use SQL Server T-SQL Function SUM: 5 Use Cases appeared first on {coding}Sight.

SQL SELECT DISTINCT: Performance Best Practices

Edwin Sanchez — Mon, 06 Sep 2021 03:57:16 +0000

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say it’s good and add DISTINCT when duplicates appear. Some say it’s bad and suggest using GROUP BY without an aggregate function. Others say DISTINCT and GROUP BY are the same when you need to remove duplicates. This post will dive into the details …

The post SQL SELECT DISTINCT: Performance Best Practices appeared first on {coding}Sight.

Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases

Manvendra Singh — Mon, 30 Aug 2021 07:45:44 +0000

There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what principal, securables, and permissions are. According to Microsoft Documentation, Securables in SQL Server context are specific resources to which the SQL Server Database Engine authorization system controls access. They are divided into …

The post Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases appeared first on {coding}Sight.

How to Use SQL SUM Function

Oleg Zhuk — Fri, 27 Aug 2021 08:01:55 +0000

SQL is a powerful and widely-used programming language for data storage, retrieval, and manipulation. One of the most commonly-used operators in SQL is SUM – a logical operation that produces the sum of all values in a column. This article will cover the basics of this operator usage in queries. Why Do You Need SQL …

The post How to Use SQL SUM Function appeared first on {coding}Sight.

User-Defined Functions in SQL Server

Josip Saban — Mon, 16 Aug 2021 08:35:26 +0000

User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many scenarios (WHERE clauses, computed columns, and check constraints), they still have some limitations and bad practices that can cause performance issues. Multi-statement UDFs might incur significant performance impacts, and this article will …

The post User-Defined Functions in SQL Server appeared first on {coding}Sight.

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

Edwin Sanchez — Thu, 12 Aug 2021 08:24:21 +0000

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 one or more columns or expressions as a basis to sort data. Then, add ASC or DESC to sort ascending or descending. ORDER BY syntax Learn the syntax of …

The post SQL Server ORDER BY Clause: The 5 Do’s and Don’ts to Sort Data Like a Pro appeared first on {coding}Sight.

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

Edwin Sanchez — Tue, 10 Aug 2021 06:56:55 +0000

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 methods is the SQL GROUP BY clause. You can use SQL GROUP BY to divide rows in results into groups with an aggregate function. It sounds easy to sum, …

The post GROUP BY in SQL Server: 3 Easy Examples to Group Results appeared first on {coding}Sight.