Skip to content

Tag Archives: postgreSQL-clauses

In PostgreSQL ,The continue statement is used to skip the current iteration prematurely and directly move on to the next iteration. The continue statement is… Read More
PostgreSQL has various techniques to delete duplicate rows. One of them is using the DELETE USING statement. Syntax: DELETE FROM table_name row1 USING table_name row2… Read More
The PostgreSQL GROUP BY clause is used to divide rows returned by SELECT statement into different groups. The speciality of GROUP BY clause is that… Read More
PostgreSQL has a HAVING clause that is used to eliminate groups of rows that do not meet specific criteria or conditions. Ii generally used in… Read More
The PostgreSQL LIMIT clause is used to get a subset of rows generated by a query. It is an optional clause of the SELECT statement.… Read More
The PostgreSQL LIMIT clause is used to get a subset of rows generated by a query. It is an optional clause of the SELECT statement.… Read More
The PostgreSQL FETCH clause has a functionality similar to the PostgreSQL LIMIT clause. It is used to retrieve a portion of rows returned by a… Read More
The PostgreSQL ORDER BY clause is used to sort the result query set returned by the SELECT statement. As the query set returned by the… Read More
The PostgreSQL WHERE clause is used to filter results returned by the SELECT statement. Syntax: SELECT select_list FROM table_name WHERE condition; Let’s analyze the above… Read More
This article will be focusing on the use of SELECT statement with the DISTINCT clause to remove duplicates rows from a result set of query… Read More