T-sql min null values

Not the most eligant way to do things, but it defeinitely gets the job done. The same method can be used on regular integer fields as well substituting a number for NULL. Then any NULL will be treated as a zero. As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. July 23, September 6, March 24, This is related to an issue I am currently having.

I have a table with contact info and a table with their orders. ID on the contacts is linked to the orders customer as a one to many relationship. Improve this answer. Chris Chris 3, 2 2 gold badges 23 23 silver badges 37 37 bronze badges. The Dag The Dag 1, 14 14 silver badges 21 21 bronze badges. NULL is a wonderful thing. This is not always the case but often is. You MUST know your data to develop a good schema and queries. I would tend to agree. As an aside, do you have an answer to the question?

I hate when users attempt to redirect the user instead of answering and -then- trying to redirect. Q: has it been modified? A: no, you are inserting the value. I keep a CreatedDate and a ModifiedDate on my data. Irshad 2, 5 5 gold badges 26 26 silver badges 47 47 bronze badges.

Scott Ivey Scott Ivey I think this would work Jason Punyon Jason Punyon For a column indicating when something was last modified NULL is the logical choice to represent "never". But if one does resort to "magic values" i. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Also, do you know which version of MySQL you have?

No you misunderstand - I was saying that the function ignores any null values when evaluating the min aggregation - it's not part of the syntax. Are you also getting null for max dob? It's not work for me. Write an Answer. Write an Answer Hint: Notify or tag a user in this post by typing username. Related Questions.

Improve Script Performance how to convert cyymmdd in oracle to datetime in sql using ssis What Should I Learn for Query Tuning SQL: Concatenating manager with their corresponding employees without repeating manager name?