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
Top
2017-06-19
1,232 reads
2015-10-22
1,840 reads
2015-10-15
1,750 reads
Selecting Data Using the TOP Clause
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
Stairway to T-SQL: Beyond The Basics Level 1: The TOP Clause
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
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
migration
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
This code works, but am requesting help with the code.
Hello everyone. I don't post here often even though I am constantly on the...
Ask SSC