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

4,812 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

Abuse, Patience, and Understanding

By

I’ve been struggling with an author for a few months. I tried to work...

Daily Coping 21 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SSIS Logging – Linking sysssislog with custom log

By

I was working on an ETL solution, which was expected to run for hours....

Read the latest Blogs

Forums

cumulative updates in multi instance standalone server

By noobdba

For 2019, how would one go about applying CU on multiple instances in a...

Powershell String was not recognized as a valid DateTime

By webrunner

Hello experts, I'm trying to import some CSV data into a SQL database using...

connecting to SQL Database from asp application and setting CONTEXT_INFO

By skb 44459

connecting to SQL Database from asp application and setting CONTEXT_INFO. <connectionStrings> <add name="CLHN_AppConnectionString" connectionString="Data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers