Skip to Content
Former Member
Dec 19, 2006 at 01:53 AM

How to get the other columns of a particular mininum value


<p>I have a multiple rows per account in a table. I build a object minimum(col1) in the Business Object universe. I need to get the corresponding values of a min(col1) for each account. Problem is when i pull the min(col1) and other column, it always gives every combination of the min(col1) for each account. How do i get only the corresponding values.</p><p>Example</p><p>Acct Col1 col2 col3 </p><p>1 34 3 4</p><p>1 45 5 6</p><p>2 3 7 8</p><p>output should be</p><p>1 45 5 6</p><p>2 3 7 8</p><p>How i accomplish with data providers or free hand sql combinations</p><p>&#160;</p><p>Thanks</p><p>&#160;</p><p>&#160;</p>