Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Top Rss

Search for any content tagged top

   Items 1 to 4 of 4   
 

Selecting Data Using the TOP Clause

There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.  Read more...
By Additional Articles 2015/04/16 | Source: Database Journal | Category: top
Rating:  Rate this |   Briefcase | 8,700 reads

Stairway to T-SQL: Beyond The Basics Level 1: The TOP Clause

The first topic in this stairway will be discussing the TOP clause. The TOP clause allows you to control the number of rows to be returned or affected by a query.  Read more...
By Gregory Larsen 2014/01/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,481 reads

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.  Read more...
By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,357 reads

Deleting Batches of Rows with TOP

Using the TOP clause in a procedure to delete records in batch.  Read more...
By Ted Manasa 2008/07/03 | Source: SQLServerCentral.com | Category: top
Rating: |  Discuss |   Briefcase | 10,633 reads
   Items 1 to 4 of 4