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,869 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

Daily Coping 24 Sept 2021

By

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

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Automatic INSERT-INTO

By LD3060

I have a view in my database where data is stored, it has 2...

Making Software Decisions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Making Software Decisions

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers