Tag: SQL Parameters

Aggregate Functions In SQL And Their Usage

Aggregate Functions In SQL And Their Usage - Enterprise DNA

In this tutorial, we’ll be discussing the different aggregate functions in SQL and how we can use them. In SQL, aggregate functions are used to accumulate data from multiple rows into a single summary row.  Aggregate functions in SQL can be very helpful for analysts when doing data summarization. Commonly Used Aggregate Functions In SQL

Continue reading

Stored Procedures In SQL | An Overview

Stored Procedures In SQL An Overview - Enterprise DNA

In this blog, we’re going to discuss stored procedures in SQL that you can utilize to save a set of code and use it repeatedly whenever you need it. Stored procedures are similar to views. However, you can conduct common table operations such as DROP, TRUNCATE, DELETE, etc. with stored procedures which you can’t perform

Continue reading