Database

This article will be looking into queries to select from multiple tables through different ways for different requirements. Table of Contents Select from multiple tables MySQL using JOINS Select from multiple tables MySQL using UNIONS Select from multiple tables MySQL using Subqueries Select from multiple tables MySQL with IN() Before moving into each section, let […]

This article will be looking into LIMIT with OFFSET, including the syntax, using examples. Table of Contents What is LIMIT with OFFSET in MySQL. Syntax of LIMIT with OFFSET Examples of LIMIT with OFFSET What is LIMIT with OFFSET in MySQL In MySQL, the LIMIT clause is used to get the limited number of rows

This article will be looking into LIMITS with OFFSET, including the syntax, using examples. Table of Contents MySQL select rows by range using LIMIT with OFFSET MySQL select rows by range using Row_Number() function Let us get started by making the data. We will be creating a table customer_name_city and inserting rows into it. Let

This article will discuss how to insert a record IF NOT EXISTS in MySQL. We will be using MySQL subqueries with NOT EXISTS clause to fulfill the purpose. Table of Contents INSERT NOT EXISTS Syntax INSERT single record if NOT EXISTS in MySQL INSERT multiple record if NOT EXISTS in MySQL INSERT record or UPDATE

The ROW_NUMBER() is a window function in MySQL that assigns a sequential number to each row. In this artifact, we will discuss the syntax and different examples around the row_number() function to clarify the concept. Table of Contents ROW_NUMBER() in MySQL Syntax ROW_NUMBER() in MySQL Examples ROW_NUMBER() in MySQL Example with Partition Using ROW_NUMBER() in

In this article, we will be discussing how to get the distinct count of rows and distinct count of values for a column from a table in MySQL. Table of Contents Select count(*) with DISTINCT syntax Select count(*) with DISTINCT examples Count DISTINCT values in a column Count(*) function in MySQL is used to get

There is often a requirement to get the top 10 rows from a table, query, or a group in a table. Let us look into each of these. Table of Contents MySQL select TOP 10 rows from a table using LIMIT clause using Row_Number() function MySQL select TOP 10 rows from a query result MySQL

In this article, we will be looking into the count() function with select statement and conditions. Table of Contents Select where count is greater than one : using HAVING Clause Select where count is greater than one : using JOINS Select where count is greater than one : using Exists Let us get started by

Count() function in MySQL is to get the number of rows in a MySQL table or expression. In this article, we will talk about the count() function with if(). We are creating a table students_data followed by adding data to it. Let us see what got into table students_data by executing: Output:- Since the data got created

This article will be taking an example table customer_data and will try to get multiple counts from this table within a single query. Topics covered: COUNT(*) GROUP BY COUNT(DISTINCT) BASED ON CONDITION Let us get started by creating the table customer_data and inserting the data into it. We will see how the data looks by executing SELECT * FROM