All articles: Data Manipulation Language (DML)

Checkout our self-help content, created by our top Experts!
How to Count Total Price in SQL – Querychat
In this article, we will learn how to count the total price in SQL with the use of the COUNT function. We will also learn the other aggregate functions in SQL, which are commonly used. Those are AVG, SUM, MIN, and MAX. Let’s discover their syntaxes and look at the...
Oracle Running Total – Querychat
In this article, we will discover how to run a total in Oracle, especially how to use the cumulative sum in SQL Oracle. We will start by comparing the ordinary aggregate SUM function and the analytic one, and then we will proceed to the Oracle running sum examples.  Aggregate SUM...
How to Check If Row Exists in MySQL – Querychat
In this article, we will find out what the EXISTS operator in MySQL is and how we can check if the row we need exists. We will look at the example to better understand the theme. MySQL exists syntax EXISTS is an operator that produces a TRUE or FALSE value,...
Oracle SQL Top 10 Rows: Select and Delete – Querychat
Sometimes we have tasks where we need to use Oracle SQL to select the top 10 rows (or any other number) in our result set. For example, if there are too many results. In this article, we will discover how to select and delete the top 10 rows in Oracle...
What is Oracle REPLACE Function – Querychat
In this article, we will learn the REPLACE function in Oracle and discover its syntax. What is more, we will discover another similar function called TRANSLATE then we will practice using both functions in our examples. Oracle REPLACE syntax In Oracle, we can replace a column string by another string...
How to Use GETDATE in MySQL – Querychat
In this article, we will discover the most frequently used date functions of MySQL. Also, we will find out how to use MySQL to get the current datetime. We will learn what each of the functions does, along with some examples.  MySQL GETDATE function There is no GETDATE function in...
How to Solve MySQL Error 1241: Operand Should Contain 1 Column – Querychat
In this article, we will learn what subqueries are in MySQL and how to solve one of the most frequent subquery errors, namely, the error “operand should contain 1 column”. What are subqueries in MySQL? A subquery is a query located in another query.  MySQL allows us to nest a...
Oracle SQL How To Find Duplicates – Querychat
In this article, we will learn how to find duplicates using SQL in Oracle in two different ways.  Getting started For our further examples and experiments, we need to create a test table.  This script will create a table called “Cars” that contains 3 columns: Car_ID, Car_Model, and Car_Color. CREATE...
SQL Server SPACE Function – Querychat
We might have never used or even heard the SPACE function before. This function is one of the string functions in SQL Server, which is used to repeat a blank space a defined number of times. In this article, we will discuss this function and take a look at some...
SQL Server CHARINDEX and PATINDEX Functions – Querychat
There might be cases when we need to identify the starting position of a character or a string within another string. In SQL Server, we can use either the CHARINDEX or PATINDEX functions to do that. This article explains the use of these two functions, their differences, and provides some...
1 2 15 16