All Articles -> SQL Server SELECT Statement

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

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

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

How to Use GROUP BY in SQL Server ( 30 July 2007 - Jeff Smith - 7 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 - 31 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 - 5 Comments)

Find Nth maximum value in SQL Server ( 11 April 2004 - Guest Authors - 14 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 - 7 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 - 3 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 - 25 Comments)

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

Returning complete words from a substring ( 9 February 2001 - Bill Graziano - 20 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 - 16 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 - 3 Comments)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -