SQL Query to Update All Columns in a Table

SQL Query to Delete a Data From a Table Based on Date

Last Updated : 06 Mar, 2023

Many of the time we have to delete data based on the date. These dates can be some older dates. For this purpose, we can use delete query along with where clause. This approach helps us to delete some old data in our database. In this article, we are going to delete the data of employees based on their birth dates.

Step 1: Creating the database

Query:

CREATE DATABASE Gfg;

Step 2: Using the database

Query:

USE DATABASE Gfg;

After executing this query we can create tables in our database.

Step 3: Table definition

Query:

CREATE TABLE EMPLOYEE (name VARCHAR(20), age VARCHAR(20),
 GENDER(20), birth DATE, Department VARCHAR(50) );

Output:

After executing this query, a table with the name Employee will get created with the specified column.

Step 4: Adding data to the table

Output:

After executing this query, records will get inserted as shown above.

Step 5: Deleting from the table based on a date

Query:

DELETE FROM Employee where birth < '2001-01-04'

In this query, we are deleting the records which have birthdate older than 2001-01-04 (year-month-date).

Output:

As we have deleted the employees whose birthdate was older than ‘2001-01-04’, we can see the employees with the date greater than and equal to 2001-01-04.

SQL Query to Update All Columns in a Table

aniketdalal126

Improve

Article Tags :

Similar Reads

How to Fetch Data From Two Tables Based on Date in SQL?

In SQL, fetching data from multiple tables based on a specific date range is a common task. By using certain SQL operations, we can combine data from two different tables and filter the results based on a date condition. This method is particularly useful when working with multiple datasets and we n

SQL Query to DELETE Certain Rows Based on Comparisons with Other Tables

In this article, we will see, how to delete certain rows based on comparisons with other tables. We can perform the function by using a subquery in place of the condition in WHERE Clause. A subquery is a query that appears inside another query. It can also be called a nested query. Syntax: SELECT *

How to Query for all Dates Greater Than a Certain Date in SQLite?

SQLite has become the preferred option for embedded databases mainly because of its lightweight attributes and user-friendliness. SQLite with dates greater than that particular date can be achieved by following the datetime functions that are given by the database engine. This possibility is extreme

How to Specify a Date Format on Creating a Table and Fill it in SQL?

Dates are a fundamental part of database management, as they provide a timeline for analyzing data trends, tracking records, and scheduling events. In SQL, handling and formatting date columns correctly ensures consistency and clarity in our database. One critical aspect of working with dates is spe

SQL Query to get first and last day of a month in a Database

In SQL, working with date and time data is critical for tasks like reporting, scheduling, and data analysis. Determining the first and last day of a month is a common requirement. SQL provides powerful functions like DATE_SUB, DAYOFMONTH, and LAST_DAY to make these calculations straightforward. In t

How to Delete a Table from a Databricks Connection

Databricks is a powerful data analytics platform built around Apache Spark. It simplifies big data processing, machine learning, and business intelligence tasks in a unified environment. One of the key tasks when working with data in Databricks is managing our tables by deleting no longer required t

SQL Query to Display Nth Record from Employee Table

In database management, retrieving the Nth record is a common operation, especially when dealing with large datasets. Whether we're debugging, analyzing specific rows, or implementing pagination, understanding how to fetch a specific record efficiently is crucial. In analysis, focusing on one partic

How to Delete a Row by Reference in data.table in R?

In R Language the data.table package is highly efficient for data manipulation, especially for large datasets. One of its powerful features is the ability to modify data by reference, which avoids copying the entire dataset and thus improves performance. This article will guide you through the proce

How to Write a SQL Query For a Specific Date Range and Date Time?

Managing date and time in SQL is a critical task for many real-world applications, especially when handling time-sensitive data such as logs, timestamps, and event records. SQL provides various tools and data types to work with date and time effectively. In this guide, we will focus on working with

How to Retrieve the Records Based on a Date from Oracle Database?

DATE is a SQL-defined data type that is used to store dates in a column, different database management systems store dates in different formats. MySQL uses 3 bytes to store dates. It stores DATE in a format like 'YYYY-MM-DD'. The DATE value ranges from 1000-01-01 to 9999-12-31. Oracle database manag