TOP vs Max/Min: Is there a difference?
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2020-08-14 (first published: 2018-12-17)
7,425 reads
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2020-08-14 (first published: 2018-12-17)
7,425 reads
2017-06-19
1,232 reads
2015-10-22
1,840 reads
2015-10-15
1,750 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-10-03
2,040 reads
2014-05-09
2,203 reads
The first topic in this stairway will be discussing the TOP clause. The TOP clause allows you to control the number of rows to be returned or affected by a query.
2019-03-26 (first published: 2014-01-15)
26,072 reads
2013-06-04
2,398 reads
2013-05-30
2,140 reads
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Hello everyone. I don't post here often even though I am constantly on the...