Worst reason ever to use a subselect in t-sql

[someone_else]

Sure, it works but...

http://www.tizag.com/sqlTutorial/sqlsubqueries.php

Comments

[khayman]

It hurts.

[someone_else]

I understand the simplicity of the example, but seriously. Wouldn't someone benefit more from an example that actually needed a sub select vs a TOP 1 ORDER BY?

[khayman]

I'm more disturbed by encouraging the nasty habits of subquerying. It's a short jump to pairing IN (or worse, NOT IN) with subqueries where performance gets wrecked. As they do later in the tutorial. They continue teaching people bad habits...

[someone_else]

Oh dear. I hadn't even seen that part of the tutorial.