I have a database with several fields...
I only want certain fields to show in my results
Some of the searched fields have the same value

example: searched field is specific_p
specific_p       comment   qty
68030              9845         0
68030              9844         100
68030              9843         12
68030rc50        9843         50

I want to show the 68030, but not the comment. I also don't want to show three 
seperate 68030s and pick one that is not 0 qty if there is one.
Is there an MSSQL command to only get one of them? 
There may be other parts that are close too I want to search for %68030% to get all of 
them but show only one of them.

I could probably write a filter, but WHY if it is built into SQL?

Reply via email to