Gå til hovedinnhold

SQL

PostgreSQL​

My best experience with SQL data bases have been PostGres by far. It is open source, works splendidly and is fast and simple to learn and use and has a lot of awesome functionality.

Links

Thoughts

  • There are two types of people in business, those who know SQL and those who do not. Be the former.
  •  Common Table Expression (CTE) using the WITH clause. A CTE is a temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. Here's a breakdown of what the code does: