All Articles -> SQL Server SELECT Statement

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

The FROM Clause ( 24 June 2002 - Bill Graziano - 2 Comments)

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

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

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

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

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

Calculating Running Totals ( 7 May 2001 - Garth Wells - 18 Comments)

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

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

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

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

The case for CASE ( 6 October 2000 - Bill Graziano - 4 Comments)

Group By using Weeks ( 2 October 2000 - Bill Graziano - 15 Comments)

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

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

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

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

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

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

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

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

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

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