Using the GROUP BY clause can be a bit mystifying to start. Let’s break down some simple rules to make the whole thing easier….
You are browsing archives for
Author: Jo Barrett
Advice to Aspiring SQL Masters, Part 1: Basic SELECT statements
In working one-on-one with many who are new to SQL, I see a lot of confusion on how to get started. In this post, I’ll give you a repeatable set of steps you can use to start writing basic SELECT queries.
Walkthrough: Building a SQL SELECT Query
A full walkthrough on building a SQL SELECT query using live data.
Concise Code with Top-Level Statements in C#
Top-level statements can look confusing to long-time .NET users, but it’s just a matter of hiding the plumbing code.
The contract has changed: Default Interface methods in C# 8.0
As long as I’ve been teaching object-oriented programming, I’ve drummed this phrase (or something like it) into my students’ heads, to get across how interfaces are different than classes: For classes: A subclass inherits from its superclass dynamically: As new members are added to the superclass, they are automatically available for the subclass (Based on […]