What are the Scalar Functions in SQL? Complete Guide

In this article we will see the Scalar Functions in SQL with practical examples. Scalar Functions Scalar functions always return a single value using the given input value. Following are some of commonly used scalar functions. It is also one of the important interview question. Your interviewer may ask you what are the Scalar Functions … Read more

What are the SQL Aggregate Functions? Complete Guide

In this article, we are going to discuss SQL Aggregate Functions using practical examples with syntax. List Of Aggregate Functions Below are the commonly used SQL Aggregate Functions. AVG – Returns the average value for the selected column in the table COUNT – Returns the number of rows for the selected column in the table … Read more