Re: simple (not for me) question

From: Kleist <kleist_at_tlen.pl>
Date: Thu, 18 Aug 2005 15:21:31 +0300
Message-ID: <de1ugg$8i1$1@news.uar.net>

Mark C. Stock wrote:

> what version of oracle are you using?
>
> you're not just looking for a list of IDs, you appear to be looking for a
> list of minimum ID for each prod_nr
>
> have you tried the GROUP BY clause?

You are dead right,

select min(ID) from table group by prod_nr

works great Received on Thu Aug 18 2005 - 07:21:31 CDT

This message: [ Message body ]
Next message: HansF: "Re: Daatabase"
Previous message: Oracle: "Vennela Technologies Conducting Corporate Training On Oracle 11i Applications"
In reply to: Mark C. Stock: "Re: simple (not for me) question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US