All articles: Data Manipulation Language (DML)

Checkout our self-help content, created by our top Experts!
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...
SQL Error: ORA 01861 Literal Does Not Match Format String – Querychat
Almost every Oracle user has encountered the “Literal does not match format string” error, which also can be identified as ORA 01861. This error usually appears when we run some statements on our table, which has a lot of data. ORA 01861 сan make beginners panic, but in this article,...
MySQL select values not in another table – Querychat
MySQL tables that are used separately for various types of entities can have relations that involve more than one related table. Such as if a row in one table is related to just one row in another table, the tables are said to have a One-to-One Relationships. But when there...
Searching by Name Using the SQL LIKE Operator – Querychat
In this article, we will learn how to use the LIKE operator to lines that satisfy our condition. For example, by using the SQL LIKE statement, we can display records of restaurants whose second letter is not in the range [g-m]. This operator is commonly used, so if we learn...
Oracle NVL vs COALESCE Functions – Querychat
In this article, we will discover what the Oracle SQL COALESCE function is and how we can use it in our work. Also, we will find out what is the NVL function and why these functions are often confused. Oracle COALESCE syntax We use this function when we need to...
What Is MySQL COALESCE – Querychat
In this article, we will learn the MySQL COALESCE function, its features and also we will discover how we can use it with some illustrative examples. The syntax of the COALESCE function We use this function when we need to get the first value of a list that is not...
1 2 15 16