Top

SQLServerCentral Article

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 […]

(6)

You rated this post out of 5. Change rating

2019-06-04

5,195 reads

Technical 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.

(1)

You rated this post out of 5. Change rating

2015-04-16

9,580 reads

Blogs

Take Time to Gain Perspective

By

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

By

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Demo for Parameter Sniffing and Memory Grant Feedback

By

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Magelang Telp:08217555651

By layanan_Bca88

Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang,...

Alamat Kantor BCA KCU KUDUS Telp:08217555651

By m4rt1n4

Hub Via Wa:628217555651 Alamat Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus,...

Alamat Kantor BCA KCU Gang Tengah Telp:08217555651

By R4nt4u

Hub Via Wa:628217555651 Alamat Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa...

Visit the forum

Question of the Day

Database Mail Configuration

If I want to get a list of the configuration settings for Database Mail using T-SQL,  how can I do so?

See possible answers