Top

External Article

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

Flyway Desktop Projects for My PoC

By

In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023

By

Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 

By

When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs

Forums

migration

By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

SSRS REPORT

By RDOT

am getting the following when run report what can I do to fix this

This code works, but am requesting help with the code.

By Doug

Hello everyone.  I don't post here often even though I am constantly on the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers