K Z, Author at Adglob Infosystem Pvt Ltd

SQL Server: Subqueries

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use subqueries in SQL Server (Transact-SQL) with syntax and examples. What is a subquery in SQL Server? In SQL Server, a subquery is a query…

SQL Server: HAVING Clause

Post author:K Z
Post published:October 7, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the HAVING clause in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server (Transact-SQL) HAVING clause is used in combination with the GROUP…

SQL Server: AVG Function

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:1 Comment

This SQL Server tutorial explains how to use the AVG function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the AVG function returns the average value of…

SQL Server: MAX Function

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the MAX function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the MAX functions returns the maximum value of…

SQL Server: MIN Function

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the MIN function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the MIN function returns the minimum value of…

SQL Server: COUNT Function

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:1 Comment

This SQL Server tutorial explains how to use the COUNT function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the COUNT function returns the count of an…

SQL Server: SUM Function

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:2 Comments

This SQL Server tutorial explains how to use the SUM functions in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the SUM function returns the summed value of…

SQL Server: GROUP BY Clause

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:1 Comment

This SQL Server tutorial explains how to use the GROUP BY clause in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server (Transact-SQL) GROUP BY clause is used in a…

SQL Server: UNION ALL Operator

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:1 Comment

This SQL Server tutorial explains how to use the UNION ALL operator in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server UNION ALL operators is used to combine the…

SQL Server: UNION Operator

Post author:K Z
Post published:October 5, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the UNION operator in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server UNION operator is used to combine the result sets…