Window Functions Window functions allow you to perform calculations across a set of rows that are related to the current row. For example; we have…
View More Advanced SQL Techniques You Should Know
Tag: SQL
Selectivity vs Cardinality
What is selectivity? Selectivity is the estimated proportion of the rows that will return from our query based on the total rows of that table.…
View More Selectivity vs Cardinality
set operators in Postgres
Postgres offers set operators that make it easy to query and filter the results of searches from your database. Set operators are used to join…
View More set operators in Postgres
Left [Outer] Join and Right [Outer] Join
LEFT OUTER JOIN / LEFT JOIN returns all the rows from the LEFT table and the corresponding matching rows from the right table. If right…
View More Left [Outer] Join and Right [Outer] Join