## Excel SUMIFS Function – Multiple Criteria

How to Use the SUMIFS Function in Excel In this tutorial, you’ll learn how to use the Excel SUMIFS function to sum cells that match multiple criteria. When aggregating in Excel, you may want to calculate the sum of numerical values that satisfy multiple conditions.The SUMIFS function allows you to find the sum of numbers that … Read more

## MySQL SHOW TABLES Statement with Examples

How to Show Tables in MySQL In this tutorial, you’ll learn how to show a list of tables in MySQL using the SHOW TABLES statement. MySQL SHOW TABLES Syntax The syntax of the SHOW TABLES statement is as follows: SHOW TABLES [{FROM | IN} database_name] [WHERE where_expression | LIKE ‘pattern’] Remarks Database_name: The name of the database … Read more

## Excel COUNTIFS Function with Examples

How to Use​ the COUNTIFS Function in Excel In this tutorial, you’ll learn how to use the Excel COUNTIFS function.  COUNTIFS() is a function to count the number of cells in a range that meet multiple criteria.  You can use COUNTIFS() to count cells that contain dates, numbers, or references containing numbers. COUNTIFS() Syntax The syntax of the COUNTIFS() function … Read more

## MySQL GROUP BY Clause with Examples

How to Use the GROUP BY Clause in MySQL In this tutorial, you’ll learn how to use the MySQL GROUP BY clause in the SELECT query to group a set of records into summary records. GROUP BY is used to group a set of records by one or more columns, and we often use it with aggregate functions such as COUNT(), SUM(), AGV(), MAX(), … Read more

## MySQL ORDER BY Clause – Sort Data in Descending Order

How to Use the ORDER BY Clause in MySQL with Examples In this tutorial, you will learn to retrieve rows of a table sorted in ascending or descending order from a MySQL database. To get the rows sorted in ascending or descending order, we use MySQL ORDER BY clause along with a SELECT statement. The syntax … Read more

## MySQL CREATE DATABASE with Examples

How to Use the MySQL CREATE DATABASE Statement In this tutorial, you’ll learn how to create a new database in MySQL using the CREATE DATABASE statement. CREATE DATABASE Syntax To create a database, you use the CREATE DATABASE statement as follows: CREATE DATABASE [IF NOT EXISTS] database_name [CHARACTER SET charset_name] [COLLATE collation_name] Remarks Database_name must be unique within the MySQL … Read more

## MySQL CREATE TABLE with Examples

How to Create Tables in MySQL Using the CREATE TABLE Statement In this tutorial, you’ll learn how to create a table in MySQL using the MySQL CREATE statement. CREATE TABLE Syntax The syntax of the MySQL CREATE TABLE statement is as follows: CREATE TABLE [IF NOT EXISTS] table_name(    column_name(s)) ENGINE=storage_engine; To define a column for the table in … Read more

## MySQL LEFT JOIN with Examples

How to Use LEFT JOIN in MySQL In this tutorial, you’ll learn how to use the MySQL LEFT JOIN.  LEFT JOIN is used to select all records from the left table and the matched records from the right table. LEFT JOIN Syntax SELECT column_name(s)FROM table1LEFT JOIN table2 ON table1.column_name = table2.column_nam Examples Suppose you have two tables, … Read more

## Excel AVERAGEIF Function with Examples

How to Use the Excel AVERAGEIF Function In this tutorial, you’ll learn how to use the Excel AVERAGEIF function. AVERAGEIF is a function to calculate the average of a group of numbers in a range of cells that meet single criteria. AVERAGEIF Syntax The syntax of the AVERAGEIF() function is as follows: =AVERAGEIF (range, criteria, [average_range]) Arguments range: A range … Read more

## MySQL ALTER TABLE Statement with Examples

How to Use the ALTER TABLE Statement In this tutorial, you’ll learn how to use the MySQL ALTER TABLE statement to add, drop, and modify columns in an existing table. You also can use the ALTER TABLE statement to add and drop a primary key, a foreign key, and other constraints on the table. Adding a single column using … Read more

## INDEX and MATCH Excel with Examples

How to Use INDEX and MATCH with Examples In this tutorial, you’ll learn how to use the combination of INDEX() and MATCH() to lookup a value and retrieve some other related information. First, learn INDEX() and MATCH(), and second, learn to use the combination of INDEX() and MATCH(). INDEX INDEX() returns a value or a reference to specified cells from within … Read more

## MySQL CASE Statement with Examples

How to Use the MySQL CASE Statement In this tutorial, you’ll learn how to use the MySQL CASE statement. CASE is a MySQL flow control statement that allows you to execute a block of SQL code when a condition is TRUE and execute another block of SQL code when the condition evaluates to FALSE. MySQL CASE Syntax The syntax of the … Read more

## MySQL DATE_FORMAT() Function with Examples

How to Use the MySQL DATE_FORMAT() Function In this tutorial, you’ll learn how to use the MySQL DATE_FORMAT() function. DATE_FORMAT() formats a date as specified. MySQL DATE_FORMAT() Syntax The syntax of the DATE_FORMAT() function is as follows: DATE_FORMAT(date, format) Arguments date: Required. The date that you want to format. format: Required. The format to use. … Read more

## C# foreach Statement with Examples

How to Use the foreach Statement in C# This tutorial describes how to use the foreach statement with examples in C#. The foreach statement executes a block of code for each element of a given collection, such as a list, dictionary, or array. Related C# tutorials: A for loop statement in C# A while loop … Read more

## MySQL DATE_ADD() Function with Examples

How to Use the MySQL DATE_ADD() Function This tutorial explains how to use MySQL DATE_ADD() function, which adds a time or date interval to a given date and returns a new date. To subtract a time or date interval from a given time, use the DATE_SUB() function. MySQL DATE_ADD() Syntax The syntax of the DATE_ADD() … Read more

## MySQL DATE_SUB() Function with Examples

How to Use the MySQL DATE_SUB() Function In this tutorial, you’ll learn how to use the MySQL DATE_SUB() function. The DATE_SUB() function subtracts a time and date interval from a given date and returns a new date. To add the date and time to a given date, use the DATE_ADD() function. MySQL DATE_SUB() Syntax The syntax of the DATE_SUB() … Read more

## MySQL NULLIF Function with Examples

How to Use the MySQL NULLIFF() Function In this tutorial, you will learn how to use the MySQL NULLIF() function, which compares two expressions and returns NULL if equal; otherwise returns the first expression. MySQL NULLIF() Syntax The syntax of the NULLIF() function is as follow: NULLIF (expression_1, expression_2) NULLIF Examples Example 1 The following … Read more

## MySQL YEAR() Function with Examples

How to Extract Year Part of a Given Date in MySQL In this tutorial, you’ll learn how to use the MySQL YEAR() function to extract the year part of a given date. YEAR() Syntax The syntax of the YEAR() function is as follows: YEAR(date) Examples Example 1: Extract the Year Part of a Specified Date … Read more

## MySQL LOCATE Function with Examples

How to Use the MySQL LOCATE Function In this tutorial, we’ll learn how to use the MySQL LOCATE function. LOCATE returns the position of the first occurrence of substring in a given string. MySQL LOCATE() Syntax The following is the syntax of the LOCATE function: LOCATE(substring, string) or: LOCATE(substring, string, position) Remarks LOCATE returns 0 … Read more

## MySQL IFNULL() Function with Examples

How to Use the MySQL IFNULL() Function In this tutorial, you will learn how to use the MySQL IFNULL() function that returns the specified value if the expression is NULL; otherwise returns that expression. If you want to compare two expressions and return NULL if they are equal, use the NULLIF() function. IFNULL() Syntax The … Read more