Learn how to strip the initial and ending characters of an SQL string. >>>
Monthly Archives: June 2025
What Is a Trigger in SQL?
Learn how to define and modify triggers in PostgreSQL, MySQL, and SQL Server. >>>
Deleting One of Two Identical Rows in SQL
Learn different approaches to deleting duplicate rows in SQL. >>>
How to Lock a Single Row in MySQL
When using InnoDB in MySQL, we need to consider the rows that are locked by our queries. We may end up locking more rows than we need to, which unnecessarily blocks other queries trying to access the same rows. In this tutorial, we’ll look at how we can run SQL statements to lock only a single row. >>>
How to Return a Single Row in a Joined Table
Learn how to return a single row in a joined table. >>>
Understanding SQL RANK() vs. ROW_NUMBER()
Learn about the difference between RANK() and ROW_NUMBER() in SQL. >>>
Save PostgreSQL Result to a File
Learn how to use PostgreSQL and its command-line interface to export query results to a file. >>>
What Does Keyword “AS” Do in SQL
Learn how to use the AS keyword in SQL queries to rename columns, tables, and subquery results in your queries and enhance the readability and manageability of your SQL code. >>>
Introduction to Apache Doris
A quick intro to Apache Doris. >>>