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

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

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

In this article, we will explain What is a subquery SQL and how to use subqueries in SQL Server (Transact-SQL) with syntax and example Furthermore, in SQL Server, a subquery is a query within a query. you are free to create...

BETWEEN SQL operator is a Logical operator in SQL, which allows you to select values that are within a specific range. the values can be text, numbers, or dates. furthermore, it has to be paired with the AND operator. The SQL...

In this article, we will learn into the “APPLY” operator and its variation- SQL Cross apply and outer apply in SQL Server along with an example of How they can be used. therefore, the SQL server supports table-valued functions, let’s know...

In this article, we learn How to use like in SQL operator, in SQL Server, using regular expressions to find and or manipulate text. therefore, we will use character sets and repetition expressions to create flexible matching patterns, and along the...

In this article, you will learn NATURAL JOIN SQL to query data from two or more tables. A natural JOIN SQL is a join that creates an implicit join which based on the same column in the joined tables. furthermore, the...

In these articles, we learn what is a cross join SQL and how to use the SQL Server CROSS JOIN to join two or more unrelated tables, The CROSS JOIN SQL produces the result set which is the number of rows...

In this article, you will learn how to use the CREATE VIEW SQL statement to create a view and explore methods to create a view in SQL using T-SQL (Transact-SQL). in this programmatical approach of creating, altering, and working with views...

In this article, you will learn What is SQL LEFT JOIN clause, and How to use it to query data from multiple tables with example. The SQL LEFT JOIN clause returns all records from the left table (T1) and matching the...

SQL Server functions are a valuable addition to T-SQL (Transact-SQL) when used wisely. a function, in any programming environment, let’s you encapsulate reusable logic and build software that is “compostable”. function hides the steps and the complexity from the code, for...

In this article create function SQL describes a way to Create a UDF function (user-defined function) in SQL by using Transact-SQL, A user-defined function could be Transact-SQL or common language runtime which accepts the parameters, and these perform an action, like...

The SQL WITH clause is very similar to the use of global temporary tables (GTT), a technique that is often used to improve query speed for complex subqueries. therefore, SQL WITH clause allows you to give a sub-query block a name...

SQL SELECT COUNT SUM AVG are aggregate Functions so, today’s you will learn SQL Aggregates function that you will calculate aggregates (SUM, AVG, COUNT). and you will also learn some intermediate SQL clauses such as (ORDER BY, DISTINCT, GROUP BY), these...

SQL SELECT MIN MAX functions The SQL MIN MAX Functions. The SELECT MIN() function returns the minimum value for a column. The SELECT MAX() function returns the maximum value for a column. SQL MIN MAX functions General syntax The general MIN...

SQL  DISTINCT SELECT eliminates duplicate records from the results, return only distinct (different) values. DISTINCT aggregates: COUNT, AVG, MAX, etc. so, it operates on one column and does not support multiple columns Suppose that in a table a column may contain many...

The SQL SELECT distinct can be used to return the specified number of records, it is a very useful clause on a large table with thousands of record available in the table and all database systems support the SELECT TOP Clause....

Summary: In this article, you will learn what is SQL ORDER BY and how to use the ORDER BY clause to sort the result and set a query by one or more columns. The SQL ORDER BY Clause is used to...

SQL DELETE Query We can delete one or more rows in a table, SQL DELETE Query with a WHERE clause to specify a search condition and DELETE statement removes zero or more rows of a table basically it’s depending on how...