SQL Group By

SQL Group By

After having talked about all the SQL Aggregate functions, there's one more topic that goes hand in hand with what we've already learned… The group by keyword.

This particular keyword allows us to take a bunch of data and mash it all together into matching groups and then perform aggregate functions on those groups (like sum and avg).

You might ask yourself why you'd want to "mash together" a bunch of data. The answer to this is best explained with an example, but let me try to put it in regular words before we jump into our example. Grouping data together allows us to look at aggregate data in relation to unique piece of data (or rows), a typical use case would be to group all the matching data together so you can get a count of the number of occurrences of specific data. An example related to grouping and counting could be a presidential election, you'll have all the votes in a database and you'll want to group that data together to get the total votes for each unique candidate...

For more info, check out the show notes via http://howtoprogramwithjava.com/session48

Episoder(112)

EP57 - From Restaurant Manager to Software Developer

EP57 - From Restaurant Manager to Software Developer

In this episode we'll talk to Yasiin, who is a graduate from the Coders Campus Bootcamp. We dive into his story about how he started his coding journey as a Restaurant Manager, and went through two C...

27 Jan 202239min

EP56 - Fun Tricks and Analytics with IntStreams in Java

EP56 - Fun Tricks and Analytics with IntStreams in Java

In this episode we'll talk about IntStreams and why they're useful in Java. IntStreams can be used to replace a common looping mechanism as well as provide a very helpful utility for gathering analyt...

25 Jan 202229min

EP55 - How to Sort with Streams in Java

EP55 - How to Sort with Streams in Java

In this episode we'll talk about how to sort a stream of objects using the ".sorted()" function. We'll also talk about the differences between using a stream to sort vs using something like Collectio...

24 Jan 202237min

EP54 - What is the Map Operation in Java Streams?

EP54 - What is the Map Operation in Java Streams?

Big announcement: today marks the launch of our brand new "Beginners only" Coding Bootcamp. If you're a beginner to coding and have spent less than about 6 months learning to code, you're a great fit ...

26 Nov 202141min

EP53 - Intro to Streams in Java

EP53 - Intro to Streams in Java

GitHub link here: https://github.com/tp02ga/FunWithStreams In this episode we'll talk about: What are streams and why you should care about them Comparing a simple Stream example to a Looping example...

19 Nov 202143min

EP52 - Most Common Functional Interfaces in Java

EP52 - Most Common Functional Interfaces in Java

In this episode we'll talk about 7 common Functional Interfaces that Java provides to us. UnaryOperator, BinaryOperator, Supplier, Consumer, Function, Predicate and BiPredicate Interested in startin...

15 Nov 202153min

EP51 - Let's Talk Lambdas in Java

EP51 - Let's Talk Lambdas in Java

In this episode we'll talk about a super useful feature that was introduced back in Java version 8, known as Lambdas. The Lambda feature is something you didn't know you desperately wanted or needed u...

12 Nov 202157min

EP50 - #3 of 3 to Getting a Job as a Coder

EP50 - #3 of 3 to Getting a Job as a Coder

In this episode we'll talk about the 3rd key to getting a job as a coder... How do you stand out from the crowd? You put in all this effort to learn how to code. You likely have a plan, you follow a c...

6 Aug 202131min

Populært innen Business og økonomi

stopp-verden
lydartikler-fra-aftenposten
dine-penger-pengeradet
e24-podden
rss-penger-polser-og-politikk
rss-borsmorgen-okonominyhetene
pengepodden-2
pengesnakk
finansredaksjonen
morgenkaffen-med-finansavisen
livet-pa-veien-med-jan-erik-larssen
utbytte
rss-sunn-okonomi
tid-er-penger-en-podcast-med-peter-warren
stormkast-med-valebrokk-stordalen
okonomiamatorene
lederpodden
rss-markedspuls-2
liberal-halvtime
arcticpodden