#sql
Read more stories on Hashnode
Articles with this tag
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...
Drawbacks aggregate functions perform aggregations over the entire table and cause multiple rows to be grouped together A window function performs...
Define temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. They work almost like subqueries. Although,...
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...
A subquery allows you to nest one SELECT statement inside another. This inner query, often referred to as a subquery, is executed independently from...
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...
