All Questions
2 questions
1
vote
1
answer
227
views
How to find a minimum value from multiple columns in a single row considering if any column contains 0 then it should not participate in comparision
I want to find minimum value from multiple columns in a single row and need to add a new column against same row containing that minimum value. I also want to consider if any of the column contains 0 ...
- 69
-1
votes
2
answers
74
views
Min function in SSMS on query with multiple columns
Struggling with MIN function. Need to grab other values on the row with the minimum value. Said differently, I have a parent item, a child item, and a qty. I need for a parent item, the child item and ...
- 212