Articles on SELECT

UNION: Selecting from multiple tables in one statement ( 8 August 2000 - Bill Graziano

Return Recordsets from Dynamic Queries called by EXEC ( 23 August 2000 - Chris Miller

Multiple record counts in one SQL statement ( 14 August 2000 - Bill Graziano

Searching two SQL 7.0 tables at once ( 21 August 2000 - Bill Graziano

Using Subqueries to Select Records ( 17 August 2000 - Bill Graziano

Other Approaches to NOT EXISTS ( 23 August 2000 - Bill Graziano

Retrieving 1 record from 2 tables with where syntax ( 5 September 2000 - Bill Graziano

What's after TOP? ( 31 August 2000 - Bill Graziano

Selecting data from different databases ( 7 September 2000 - Bill Graziano

Finding the Most Popular Field Values ( 8 September 2000 - Bill Graziano

Union of two full text queries without duplicates ( 23 October 2000 - Bill Graziano

Group By using Weeks ( 2 October 2000 - Bill Graziano

The case for CASE ( 6 October 2000 - Bill Graziano

Multiple Joins to the same Table in a Query ( 30 November 2000 - Bill Graziano

Returning complete words from a substring ( 9 February 2001 - Bill Graziano

Parsing CSV Values Into Multiple Rows ( 19 February 2001 - Rob Volk

Calculating Running Totals ( 7 May 2001 - Garth Wells

Selecting Based on a Version Field ( 10 June 2001 - Bill Graziano

Counting Transactions per Hour using a Pivot Table ( 9 September 2001 - Garth Wells

Keyword search using a tally or sequence table ( 8 October 2001 - Damian Maclennen

Using Derived Tables to Calculate Aggregate Values ( 18 November 2001 - Garth Wells

Fun with numbers in T-SQL queries ( 9 June 2002 - Bill Graziano

The FROM Clause ( 24 June 2002 - Bill Graziano

Converting Multiple Rows into a CSV String (Set Based Method) ( 9 September 2002 - Jay White

Using a CSV with an IN sub-select ( 13 October 2002 - Bill Graziano

Performing case sensitive searches in SQL Server ( 21 December 2002 - Bill Graziano

Detecting "Runs" or "Streaks" in your data ( 16 February 2003 - Jeff Smith

Using the PARSENAME function to split delimited data ( 10 November 2003 - Damian Maclennen

What is the difference between SET and SELECT? ( 15 February 2004 - Bill Graziano

Find Nth maximum value in SQL Server ( 11 April 2004 - Guest Authors

Computing Percentiles in SQL Server ( 20 May 2004 - Guest Authors

Computing the Trimmed Mean in SQL ( 29 June 2004 - Guest Authors

Counting Parents and Children with Count Distinct ( 10 January 2006 - Mark Caldwell

Using XQuery, New Large DataTypes, and More ( 9 May 2006 - Bill Graziano

Server Side Paging using SQL Server 2005 ( 4 January 2007 - Bill Graziano

SQL Server 2005: Using OVER() with Aggregate Functions ( 21 May 2007 - Jeff Smith

How to Use GROUP BY in SQL Server ( 30 July 2007 - Jeff Smith

How to Use GROUP BY with Distinct Aggregates and Derived tables ( 31 July 2007 - Jeff Smith

Writing Outer Joins in T-SQL ( 11 February 2008 - Kathi Kellenberger

Joining to the Next Sequential Row ( 2 April 2008 - Paul Alcon