Top

A Plunge Into TOP

  • Article

Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]

5 (6)

2019-06-04

3,776 reads

Selecting Data Using the TOP Clause

  • Article

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.

2015-04-16

9,580 reads

Blogs

Last Week Reading (2019-06-16)

By

Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of...

Back with new focus

By

Back with a new focus First let me say wow can’t believe that it...

A Double Day

By

I’m traveling back from Australia today. A few weeks ago I lost a day...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Temporary data and Differential Backup size

By Thomas Franz

Comments posted to this topic are about the item Temporary data and Differential Backup...

Watching Out for Deferred Name Resolution

By Tony Davis

Comments posted to this topic are about the item Watching Out for Deferred Name...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers