What is Joins ? Joins are basically a technique to link data together link two tables together on a common column. That will allow you
Tag: postgresql
PostgreSQL – Correlated Subqueries
What is Correlated Subqueries ? A correlated subquery is a query nested inside of another that uses values from the outer query.It uses values from
PostgreSQL – Conditional Expressions CASE WHEN THEN
Conditional Expressions we want to have a conditional situation where we say OK if this salary is less than a certain number then the result
PostgreSQL – Subqueries
what’s a subquery ? It’s actually a query that exists within a query.So a query within a query a select statement within a select statement.
PostgreSQL – GROUP BY, HAVING
I wanted to get the the total salary paid by each department I could do that by doing a sum. SELECT SUM(salary) FROM employees if
Postgres Command Line
psql: FATAL: password authentication failed for user error while trying to access psql Ans psql by default will use the same username as your OS