In this PostgreSQL tutorial, we will learn about PostgreSQL Data Types. Here we will learn about the different data types available in PostgreSQL with examples. PostgreSQL Data Types PostgreSQL upholds a vast range of Data Types. It contains several data types, including Boolean, Numeric, Character, Temporal, Array, JSON, UUID, and special data types. When generating … Read more >>
Say you need every order over $100 from a US store’s October 2026 sales. The PostgreSQL WHERE clause keeps only rows where the condition is true: I tested this in psql on PostgreSQL 18.6, Windows 64-bit: Sample tables for the WHERE examples Six customers, seven orders. Guest order 106 (NULL customer_id), the NULL coupons and … Read more >>
The MariaDB delete row statement is one line: DELETE FROM orders WHERE id = 108; Leave out the WHERE and the whole table empties. My first filtered delete, on a non-key column, removed nothing: ERROR 1175, safe update mode. Quick answer: filter on the primary key, read ROW_COUNT() afterward, and wrap anything bigger in START … Read more >>
I am currently working on the Employee Leave Management System in SQL Server. I have a requirement to use the SELECT statement without the JOIN clause to retrieve records from two tables by query. This tutorial will teach how to use SQL Server SELECT statements without using the JOIN clause on the query’s table. SQL Server Select a Join … Read more >>
Duplicate rows after a join in SQL Server almost always mean a one-to-many match, not a bug. The usual fix for distinct in join SQL Server queries is DISTINCT right after SELECT: SELECT DISTINCT c.Customer FROM dbo.Customers AS c JOIN dbo.Orders AS o ON o.CustomerID = c.CustomerID; It collapses the repeats. My verdict after testing … Read more >>
In this article, I will guide you through the full spectrum of the PostgreSQL SELECT statement—from core syntax and logical execution order to advanced pattern matching, relational joins, Common Table Expressions (CTEs), window functions, and query optimization strategies. PostgreSQL SELECT The Anatomy of a PostgreSQL SELECT Statement The SELECT statement retrieves rows from one or … Read more >>
Your backup job runs every night, and nobody has restored a single file from it. I ran the dump and restore commands below on PostgreSQL 18.6 on Windows 11 and kept the errors I hit. Quick answer: to backup PostgreSQL database contents you can restore, run pg_dump in custom format, create an empty database, and … Read more >>
Recently, I got the requirement to get the month name from a specified date in SQL server. This article will discuss multiple approaches to achieve this functionality. How To Get Month Name From Date In SQL Server Let us discuss all the approaches individually. Approach-1 Using DATENAME() We can use the DATENAME() in an SQL … Read more >>
This tutorial is about the loops in SQL Server stored procedure. You will learn how loops work in stored procedures. You will see a number of examples of loops in stored procedures in SQL Server. SQL Server stored procedure for loop SQL Server does not support FOR loop. However, you can use the WHILE loop … Read more >>
This Azure SQL article will help you to get familiar with stored procedures in an Azure SQL database. We will explain how to create stored procedures in an Azure SQL database with the help of some examples. How to create stored procedure in Azure SQL database In this section, I will explain how to create … Read more >>