Getting the minimum of two values in SQL

by

SQL Server 2012 and 2014 supports IIF(cont,true,false) function. Thus for minimal selection you can use it like

SELECT IIF(first>second, second, first) the_minimal FROM table

While IIF is just a shorthand for writing CASE...WHEN...ELSE, it’s easier to write.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. SQL Server dynamic PIVOT query?
  3. T-SQL stored procedure that accepts multiple Id values
  4. Understanding PIVOT function in T-SQL
  5. SQL Server Process Queue Race Condition
  6. How do I escape a percentage sign in T-SQL?
  7. Using RegEx in SQL Server
  8. Creating an index on a table variable
  9. OR is not supported with CASE Statement in SQL Server
  10. Parse comma-separated string to make IN List of strings in the Where clause
  11. How do I use the CONCAT function in SQL Server 2008 R2?
  12. Pivot using SQL Server 2000
  13. EXEC sp_executesql with multiple parameters
  14. Equivalent of Oracle’s RowID in SQL Server
  15. How to update and order by using ms sql
  16. How to store image in SQL Server database tables column [duplicate]
  17. How to add custom attributes to SQL connection string?
  18. SQL “between” not inclusive
  19. Extract the first word of a string in a SQL Server query
  20. Can I set ignore_dup_key on for a primary key?
  21. SQL Server replace, remove all after certain character
  22. Inserting rows into a table with one IDENTITY column only [duplicate]
  23. Compute MD5 hash of a UTF8 string
  24. LPAD in SQL Server 2008
  25. When using GETDATE() in many places, is it better to use a variable?
  26. How do I remove non-breaking spaces from a column in SQL server?
  27. COALESCE Function in TSQL
  28. How to set value to variable using ‘execute’ in t-sql?
  29. Using a variable for table name in ‘From’ clause in SQL Server 2008
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment