Re: Need Distinct and Min...

2003-02-17 Thread Lewis Watson
ROTECTED]> Sent: Monday, February 17, 2003 5:02 AM Subject: Re: Need Distinct and Min... > * Lewis Watson > > I have a table with three fields. In the first field I have a range of > > numbers 1-20; all repeated more than once. In the third field I have a > > number ranging f

re: Need Distinct and Min...

2003-02-17 Thread Egor Egorov
On Monday 17 February 2003 04:20, Lewis Watson wrote: > I have a table with three fields. In the first field I have a range of > numbers 1-20; all repeated more than once. In the third field I have a > number ranging from 1 to 20 in each row. I need to choose the > lowest amount in the thi

Re: Need Distinct and Min...

2003-02-17 Thread Roger Baklund
* Lewis Watson > I have a table with three fields. In the first field I have a range of > numbers 1-20; all repeated more than once. In the third field I have a > number ranging from 1 to 20 in each row. I need to choose the > lowest amount in the third column for each distinct value in the

Need Distinct and Min...

2003-02-16 Thread Lewis Watson
I have a table with three fields. In the first field I have a range of numbers 1-20; all repeated more than once. In the third field I have a number ranging from 1 to 20 in each row. I need to choose the lowest amount in the third column for each distinct value in the fist column. Will some