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

Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2

By

How to read execution plan to improve poorly... [[ This is a content summary only....

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Use T-SQL, not the GUI

By

There’s a very good reason to do most of your DBA work using T-SQL,...

Read the latest Blogs

Forums

business intelligence development studio(Bids)

By Nivs719

Hello, I have a SQL 2017 and I want to use business intelligence development...

MEMORY CONSUMPTION SQL 2012

By sharon-472085

hi all, as you can see in attachment sql take 122  giga memory. and...

Issue with max() and aggregate, missunderstanding

By insomnius

Hi all, this is my first post here and I've been looking and trying...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers