PostgreSQL Archives - Database Tips

Presto: SQL over big data, NoSQL and relational DBMS

What about using SQL to retrieve data from NoSQL databases? Or to make joins between tables stored in relational databases[…]

A Sequence is a database object capable to generate numbers (i.e. it is a number generator). One of the main[…]

In SQL, The Count function counts the number of values in a set. Such function accepts a parameter, that specifies[…]

It is really common to have columns that stores sequences of numbers in database systems (specially in relational databases). Users[…]

Joins are one of the most common operators in SQL queries. In this post, we present inner and outer joins[…]

Are PostgreSQL and Ingres related? What MariaDB, MySQL and Infobright have in common? What is the origin of Microsoft SQL[…]

Duplicate data can be generated in the database due to design error, software bugs or misuse by end users. Depending[…]

Non-correlated subqueries (where the inner query does not have any column from the outer query tables) are usually implemented using[…]

LEAD and LAG are window functions that enable the simultaneous access to a table’s row and to other row related[…]

There are a lot of options to use when testing for NULL values in SQL. One should use built-in functions[…]