server case
...
SQL If Else
...
SQL WHERE Clause | What is the WHERE Clause in SQL? with Example
...
SQL WHERE AND, OR, NOT Operators and How to Use or in SQL
In this article, you will learn SQL WHERE AND, NOT, OR in SQL Operator, and How to use or in SQL with an example, let,s discussed in detail. therefore, you will learn AND condition, OR condition, NOT condition with WHERE Clause...
SQL IN Statement | Case Statement IN SQL With Example
Summary: In the SQL IN Statement article, you will learn how to use the SQL IN Statement or Operator to check whether a value matches any value in a list. The SQL IN Statement or operator is a logical operator that...
ISNULL SQL Function | How to use SQL ISNULL Function with Example
In this article, you will learn IsNull SQL Function and How to use the SQL Server (Transact-SQL) IsNull() Function to replace NULL with a specified value in expressions or table records with examples. Overview: ISNULL() SQL Server function We can replace...
SQL Aggregate Functions | What are Aggregate functions in SQL
In these articles, you will learn about the SQL Aggregate functions such as COUNT(), AVG(), SUM(), MIN(), MAX(). The SQL Aggregate functions calculate on a set of values and return a single value, such as for example, the SUM function SUM()...
SQL User Defined Functions | What are SQL user Defined Functions
In this article, you will learn about SQL User Defined Functions including scalar-valued functions that return a single value and table-valued function which return rows of data. therefore Like SQL functions in programming languages, SQL Server user-defined functions are routines that...
SQL Inner Join Keyword | What is inner join in SQL with Example
In these articles, you will learn how to use the SQL INNER JOIN clause to query data from multiple tables, The SQL Inner Join is the most commonly used Joins in SQL Server, The inner join SQL clause allows you to...
What are SQL functions? | SQL aggregate functions and Scalar Functions
In this article, we learn SQL Functions like aggregate and Scalar Functions. A function is a predefined formula that takes one or more arguments as input then the process arguments are returns an output. SQL has many built-in functions for performing...