Articles tagged with: Postgres
One of the questions I got asked today is what the difference is between the SQL commands DELETE and TRUNCATE. So here we’re looking at the differences between DELETE and TRUNCATE.
In Postgres and MySQL database, there is a neat functionality which returns results from a specific range of rows. This is done using LIMIT and OFFSET. The examples in this article demonstrate how they work.