Skip to content
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
Tomas Lind
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software

Daily Archives: 2014/08/16

  1. Home>
  2. 2014>
  3. August>
  4. 16
Read more about the article Max or min value from a set of columns
Microsoft SQL Server

Max or min value from a set of columns

  • Post author:Tomas Lind
  • Post published:2014/08/16
  • Post category:T-SQL/Tips & Tricks
  • Post comments:0 Comments

The min and max aggregates in SQL Server are normally used to work over rows, getting the max or min value from a set of rows. But what if you want to get the max or min value from a set of columns instead?

(more…)

Continue ReadingMax or min value from a set of columns

confided data manager

Get compliant with the GDPR!


High Coast Database Solutions

High Coast Database Solutions

sql server consulting services


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • Using MapForce to insert hierarchical XML to relational tables
  • How to align columns in Notepad++
  • SQL Server Alert not firing
  • An alternative to xp_fixeddrives
  • CDC Cleanup job

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright - OceanWP Theme by OceanWP