The subqueries in SQL are the queries that are inside another query. This query can be set inside any clause like WHERE, HAVING, FROM, etc. These subqueries are likewise known as nested queries. The major aim of subqueries is to retrieve data from the table. It is also used as a condition to fetch the …
In relational databases, we deal with various data values with different data types. The date and time values can also be a part of the database. Sometimes, we need to deal with these values as well. In this article, we are going to study the calculation performed on date and time related values. Let me …
Performing Calculations On Date-Time Related Values Read More »
New developers often get confused between NULL, empty and zero values. However, it is not that complicated. In this tutorial, we will be learning what is the NULL value and what is the IS NULL operator in PostgreSQL. So, let’s get started! Introduction to PostgreSQL IS NULL Operator In any programming language, the NULL value …
The UNIQUE constraint, as the name suggests, enforces the table to contain the unique data. In this tutorial, we will be learning about the unique constraints in PostgreSQL with some examples. So, let’s get started! Also Read: PostgreSQL SELECT Statement PostgreSQL UNIQUE Constraint Introduction In the application, you often need the table column to have …
PostgreSQL UNIQUE Constraint: Introduction, Syntax & Examples Read More »
In this tutorial, we will be learning about the primary key constraint in PostgreSQL. It is one of the most important constraints that is used in any application out there in the world. So without wasting time, let’s get started! Also Read: PostgreSQL TRUNCATE TABLE What is a Primary Key? In simple terms, the primary …
PostgreSQL Primary Key Constraint (With Examples) Read More »
In this tutorial, we will be learning about the LIKE operator which is a pattern-matching operator used to fetch data based on a specified pattern. We will see multiple patterns available to use with the LIKE operator and implement them in real-world examples. So, let’s get started! Introduction to PostgreSQL LIKE Operator The LIKE operator …
PostgreSQL LIKE Operator: Query Data Using Pattern Matching Read More »
In this tutorial, we will learn how to use the IN operator in PostgreSQL to filter the data. It is used with the WHERE clause to get the targeted rows by checking if the column value matches any value in the specified list. We will be learning some exciting stuff here, so hang in with …
PostgreSQL IN Operator: Filtering Data Using Multiple Values Read More »
In this tutorial, we will be learning to use the BETWEEN operator in PostgreSQL. It is used to check if the given value lies within the specified range. This is going to be a super easy tutorial, so let’s get straight into it. Introduction to PostgreSQL BETWEEN Operator When you want to check if a …
PostgreSQL BETWEEN Operator: Query Data Within Specified Range Read More »
In this tutorial, we will be learning about the FETCH clause in PostgreSQL. The FETCH clause is very similar to the LIMIT clause, therefore if you know how LIMIT works, then you will understand the FETCH clause very easily. So without further ado, let’s get started! Introduction to PostgreSQL FETCH Clause As said earlier, the …
PostgreSQL FETCH Clause: Introduction, Syntax & Examples Read More »
In this tutorial, we will be learning about the LIMIT and OFFSET keywords in postgresql which are used to control the number of records in the output. Both terms are super easy, so be with us and without wasting the time, let’s get straight into the topic. The PostgreSQL LIMIT and OFFSET clauses are used …
PostgreSQL: A Guide to LIMIT and OFFSET With Examples Read More »