The Baeldung logo
  • The Baeldung Logo
  • Start Here
  • Courses ▼▲
    • Learn Java Collections

      Explore the Java Collections Framework and Algorithms

    • Learn Spring

      From no experience to actually building stuff​

    • Learn Maven

      Simplify your build with Apache Maven

    • View All Courses

  • Pricing
  • About ▼▲
    • Full Archive

      The high level overview of all the articles on the site.

    • About Baeldung

      About Baeldung

Monthly Archives: July 2024

Changing a Table’s Storage Engine in MySQL

Lean how to change a table’s storage engine in MySQL. >>>

JOIN Syntax vs WHERE JOIN in SQL

Explore the differences between queries with JOIN and WHERE. >>>

How to Parameterize an SQL IN Clause

Learn how to parameterize an SQL IN clause. >>>

How to Remove Duplicate Rows in SQL

A quick tutorial on removing duplicate rows in a SQL database. >>>

Dropping a Database Table if It Exists in SQL

Learn to delete a table safely. >>>

Altering a Column From NULL to NOT NULL in SQL

Learn about ways to modify the current NULL constraint of a column in SQL. >>>

How to Determine the Data Type of a Column Using SQL

Learn how to find the data type of a column or all columns in relational databases (PostgreSQL, MySQL, MariaDB, SQL Server…). >>>

How to Use GROUP BY on Multiple Columns in SQL

Learn how to use GROUP BY on multiple columns in SQL. >>>

Difference Between Joins and Subqueries

Learn the difference between joins and subqueries. >>>

How to Ignore an Index in an SQL Query

Learn about running an SQL query by excluding all or specific indexes. >>>

  • ↑ Back to Top
  • 1
  • 2
  • 3
  • 4
  • 5
  • Next →
Authors – All
Authors – All

Recent Posts

  • Import an SQL File Using the Command Line in MySQL
  • Introduction to CrateDB
  • How to Retrieve the Database Size?
  • Viewing Roles and Permissions Granted to Users of Azure SQL Server Instance
  • How to Exclude a Column Using SELECT EXCEPT in SQL

Recent Comments

  1. Ulisses Lima on How to Remove Duplicate Rows in SQL
  2. Giri on How to Remove Duplicate Rows in SQL
The Baeldung logo

Categories

  • Database Concepts
  • SQL Queries

About

  • About Baeldung
  • The Full Archive
  • Editors
  • eBooks
  • FAQ
  • Baeldung Pro

Archives

  • September 2025
  • August 2025
  • July 2025
  • June 2025
  • May 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • June 2024
  • May 2024
  • April 2024
  • February 2024
  • December 2023
  • September 2023
  • August 2023
  • June 2023
  • March 2023
  • August 2022

Categories

  • Database Access
  • Database Concepts
  • database-manipulation
  • Databases
  • DDL
  • DML
  • Security
  • SQL Basics
  • SQL Constraints
  • SQL Functions
  • SQL Joins
  • SQL Operators
  • SQL Programming
  • SQL Queries
  • SQL Tables
  • SQL Views
  • Terms Of Service
  • Privacy Policy
  • Company Info
  • Contact
The Baeldung Logo