The SQL Subquery

The SQL Subquery

Author: Trevor Page: Java Guru | Programmer | Teacher June 26, 2014 Duration: 48:11

The SQL Subquery



Now that you've learned about SQL Joinsaggregate functionsand the group by keyword, it's time we moved on to our final topic in our SQL tutorial series. Today you'll be learning all about SQL Subqueries, how to use them and when you should use a SQL subquery.

So, what is a subquery?

First and foremost, let's get the jargon out of the way. A subquery can also be referred to as a nested query. It's just like having a nested if statement in your Java code. Essentially what you're doing with a subquery is you are constructing a regular old query (select statement) which could be run all by itself if you wanted to, but instead of running it all by itself, you're jamming it into another query (select statement) to give you more specific (filtered) results.

What's very important to note here is that the SQL subquery can almost always be re-written as a join with a whereclause attached to it.

More info on this via http://howtoprogramwithjava.com/session49


The How to Program with Java Podcast is a practical guide for anyone wanting to build software, from curious beginners to those looking to solidify their professional skills. Host Trevor Page, a seasoned Java guru and teacher, breaks down complex programming concepts into clear, manageable lessons you can apply immediately. You'll hear detailed walkthroughs on building applications, understanding core principles like object-oriented design, and navigating the tools of the trade. The discussions move beyond dry theory, focusing on the real-world logic and problem-solving that defines a career in software development. Whether you're aiming for a new job, tackling a personal project, or helping a child explore technology, this podcast provides a structured, conversational path forward. Each episode is crafted to demystify the process, translating technical jargon into plain English so you can focus on creating functional code. The tone is direct and encouraging, rooted in Trevor's experience as both a programmer and an educator. It’s a resource for building a tangible skill set, episode by episode, where consistent listening translates directly to growing competency. You’ll find the content naturally bridges the categories of technology education and career development, making it a useful companion for your learning journey.
Author: Language: English Episodes: 113

How to Program with Java Podcast
Podcast Episodes
Variables in Java [not-audio_url] [/not-audio_url]

Duration: 31:41
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Intro - Who is Trevor Page? [not-audio_url] [/not-audio_url]

Duration: 19:33
Here's episode 1 of the How to Program with Java Podcast. I'm very excited to kick off this podcast and can't wait to see where this journey takes me! Who am I? - Trevor Page - 38 Years old - I Live near Toronto, Ontario…