Re: Grouping

sorry posted at the same time..


"Simon Bridgewater" <simon@xxxxxxxxxxxxx> wrote in message
news:AcCZe.3633$3q4.779@xxxxxxxxxxxxxxxxxxxxxxx
> if you only want an array with the id
> then
>
> SELECT distinct(id) FROM the_table where type='whatever';
>
> "CyberDog" <milan-SPAM-@xxxxxxxxxxxx> wrote in message
> news:dh6o5c$q0q$1@xxxxxxxxxxxxxxxxx
> > Hello!
> >
> > I have an tatable with records defined by 3 values, let's call them
> > "id", "name" and "type".
> >
> > Now, I need to call all the records of one type, group them by the ID
> > value, and put only one of the same ID in an array, how to pull this off
> > without loops and easy on the load?
> >
> > Thank you in advance!
>
>


.

Relevant Pages

  • Re: Global array operations: a performance hit?
    ... as if many DO loops were executed instead than just one. ... global array operations then? ... Note that the usual terminology is something more like "whole array ... once in a while they might also get you faster execution, ...
    (comp.lang.fortran)
  • Re: Puppy Mastiff wants to Nip at Faces
    ... first couple of weeks of an introductory data structures ... it seems to me by my recollection that loops were... ... in my first college textbook on structured programming. ... they did was loop through an array to show how you could easily access ...
    (rec.pets.dogs.behavior)
  • Re: Inefficient code?
    ... line is written to the output file. ... or read it into an array. ... # Backup File Field Positions ... Define 'my %found;' above the loops. ...
    (perl.beginners)
  • Re: Global array operations: a performance hit?
    ... when using array operations you have additional information ... which is not always the case in DO loops. ... optimizing array expressions. ... The compiler has to ...
    (comp.lang.fortran)
  • Re: Skins - a great solution
    ... >> taking the top left bit as transparent you load it into a picture box ... C++ loops are obviously faster. ... would be to loop through the pixels in the array, directly, without calling ... I don't know how to get at the byte array from a bitmap handle. ...
    (microsoft.public.vb.winapi)