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
5,222 reads
2015-10-22
1,871 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,241 reads
2013-06-04
2,432 reads
2013-05-30
2,164 reads
2009-03-18
5,261 reads
2008-07-03
10,767 reads
By Steve Jones
This month I want to look at a few of the things I’ve seen...
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
By James Serra
(This post starts a three-part series on how AI is changing the way we...
Comments posted to this topic are about the item Hyperscale Replicas V
Comments posted to this topic are about the item A Heavy Heart
Comments posted to this topic are about the item Calculating Weighted Average in Power...
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers