Search for a command to run...
Articles tagged with #sql
SQL date format is YYYY-MM-DD HH:MM: SS Dates can be in different formats because: Data manipulation in Excel MM/DD/YYYY Data was manually entered Data uses text to record months Functions SELECT DATE_TRUNC('day', date), SUM(total) FROM supermar...
Drawbacks aggregate functions perform aggregations over the entire table and cause multiple rows to be grouped together A window function performs calculations across a set of table rows that are somehow related to the current row. Windows functions ...
Define temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. They work almost like subqueries. Although, subqueries are typically used within the context of a larger query and are not reusable, whereas CTE...
Joins is a clause in SQL used to combine rows from two or more tables based on a related column. Tables that share information have a primary key that identifies the entity uniquely across the database. JOIN combines row data across separate tables u...
A subquery allows you to nest one SELECT statement inside another. This inner query, often referred to as a subquery, is executed independently from the outer query. Subqueries can be found in the SELECT statement, WHERE, HAVING clause and the FROM s...
One of the key features of SQL is its ability to perform aggregate functions and group data, allowing us to extract meaningful insights from large datasets. In this article, we'll dive into some of the most commonly used aggregate functions and explo...
