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 […]
2019-06-04
4,979 reads
2015-10-22
1,838 reads
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
2014-05-09
2,201 reads
2013-06-04
2,395 reads
2013-05-30
2,137 reads
2009-03-18
5,231 reads
2008-07-03
10,688 reads
By Jen McCown
Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...
Comments posted to this topic are about the item How to use PowerShell to...
Hello everyone, Hi have this column named Sex and it only has value 0...
I have compared two tables with the same data in two different databases(aslo the...
Ask SSC