top value

Results 1 to 2 of 2

Thread: top value

  1. #1
    Join Date
    Dec 1969

    Default top value

    Hi<BR>I have an event table. I want to get the first event (starting date) and all the events with the same name (though they are on different date) as group.<BR>how can i do that.<BR><BR>thanks for help<BR>Julie

  2. #2
    Join Date
    Dec 1969

    Default RE: top value

    You don&#039;t say what DB! You will need to list all the fiels you want because of the group clause<BR><BR>Select name, &#060;ListofOtherFields&#062; from events Group by name order by startingdate asc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts