Discuss a general approach to calculating a 7-day rolling average, including indexed views in MSSQL Server, materialized views in MySQL, and materialized views with refresh in PostgreSQL. >>>
Monthly Archives: November 2024
Sorting by a List of Strings in SQL
Learn how to sort a list of strings alphabetically or in a specific order. >>>
What Does Collation Mean in SQL?
Explore the concept of collation in SQL databases and understand how it affects text comparison and sorting. >>>
Adding a Comment to a Column When Creating a Table in SQL
Learn how to add a comment to a column when creating a table in various SQL platforms. >>>
How to Loop Through a Set of Records in SQL
Learn how to loop through a set of records using various methods in SQL. >>>
Using CASE Statements in SQL SELECT Queries
Learn how to combine SELECT queries with CASE statements for complex conditional checks. >>>
Query to Retrieve Rows With Datetime Column Equal to Today in SQL
Learn to filter rows for today’s date. >>>
Detecting Locked Tables in MySQL
Explore several techniques for identifying locks, including SHOW OPEN TABLES, GET_LOCK, and performance_schema.metadata_locks. >>>
Counting Distinct Values With Conditions in SQL
Explore several techniques for counting distinct values with conditions in SQL, focusing on a university database as the example. >>>
How to Insert a CSV File Into an SQL Table
Learn to import data from a CSV (Comma-Separated Values) file into an SQL table. >>>