Subqueries examples

Question

Subqueries examples

VoldemarG

Hall of Fame

Points: 3883
More actions
March 17, 2019 at 8:09 am

#416879

Someone new to SQL asked me to show him a dozen of subqueries samples for Northwind or AdventureWorks databases. Does anyone know where i could find such samples?
I can only come up with a couple of basic examples (like 'show all products that have never been ordered...).
thanks.
Likes to play Chess

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182916 More actions · Answer 1

VoldemarG - Sunday, March 17, 2019 8:09 AM
Someone new to SQL asked me to show him a dozen of subqueries samples for Northwind or AdventureWorks databases. Does anyone know where i could find such samples?
I can only come up with a couple of basic examples (like 'show all products that have never been ordered...).
thanks.

On a high level, you got two options here, CTE or SubQuery, the latter has two further options of correlation. Anyone asking you of dozen of examples of what they don't know what is sounds a bit peculiar to say the least.
😎

usererror Ten Centuries Points: 1148 More actions · Answer 2

This request also sounds odd to me. I'm also a newbie and I don't even know what to ask online until I encounter something new I can't figure out. Odd that I come to visit the site today and see this question as I just downloaded the Adventure Works DB to look at Pivots.

-Mark
MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 3

usererror - Monday, March 18, 2019 7:25 AM
This request also sounds odd to me. I'm also a newbie and I don't even know what to ask online until I encounter something new I can't figure out. Odd that I come to visit the site today and see this question as I just downloaded the Adventure Works DB to look at Pivots.

If by "pivots", you mean the PIVOT operator, have a look at the following two articles...
Cross Tabs and Pivots, Part 1 â€“ Converting Rows to Columns[/url]
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

usererror Ten Centuries Points: 1148 More actions · Answer 4

Jeff Moden - Monday, March 18, 2019 10:09 AM
usererror - Monday, March 18, 2019 7:25 AM
This request also sounds odd to me. I'm also a newbie and I don't even know what to ask online until I encounter something new I can't figure out. Odd that I come to visit the site today and see this question as I just downloaded the Adventure Works DB to look at Pivots.
If by "pivots", you mean the PIVOT operator, have a look at the following two articles...
Cross Tabs and Pivots, Part 1 â€“ Converting Rows to Columns[/url]
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

Jeff, that is exactly what I meant. 🙂 I have been looking at some other articles about PIVOT.

-Mark
MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.