Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 2: Writing Subqueries RE: Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 2: Writing Subqueries
Peter McLean
Old Hand
Points: 383
More actions
January 15, 2014 at 9:37 am
#1680340
I think there is a typo in Listing 1 - the subquery in the column list is counting the total orders which have a 'ModifiedDate' of 2007-02-19. Should this not be total orders which have an 'OrderDate' of 2007-02-19?