You can easily create test data to help debug SQL statements:
Please remember to subscribe to the newsletter to stay up to date!
with data (key, value) as ( values ('key1', 'a') , ('key2', null) , ('key3', 'z') ) select 'min', min(coalesce(value,'')) from data union select 'max', max(coalesce(value,'')) from data
You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...
You must log in to post a comment.