Re: Compound index and unique

From: Fred Taylor (!REMOVE)
Date: 02/19/05

  • Next message: "Newbie SQL Left Outer Join"
    Date: Sat, 19 Feb 2005 11:15:33 -0700

    Yes, that is the purpose of GROUP BY, to create groups of like items. The
    MIN() will return the earliest date within that group.

    Microsoft Visual FoxPro MVP
    "Charles" <> wrote in message
    > On Sat, 19 Feb 2005 11:00:31 -0700, "Fred Taylor"
    > <!REMOVE> wrote:
    >>Forget about using a UNIQUE index, you're just asking for trouble and/or
    >>If you need a list for display purposes, then do a SQL SELECT using the
    >>MIN() SQL function:
    >>SELECT item,MIN(yourdate) FROM yourtable GROUP BY item INTO CURSOR
    > The list is then link back to an cursor to replace the earliest date
    > all items with the earliest I get from the filtered or subset I have.
    > Then use the earliest date to determine a offset to the start of the
    > other activity.
    > So the grouping by will return me my uniqueness of the item?
    > Thanks for the quick response. 

  • Next message: "Newbie SQL Left Outer Join"