Do you think it would be a reasonable request for enhancement to the select command to allow ascending and descending to work the way I described? Based on the published syntax it looks like what I'm trying to do should work but I can't make it work
> On Dec 27, 2014, at 10:32 AM, "Dr. Fritz Luettgens" <[email protected]> > wrote: > > Hi Mike, > I work a lot with statistics, what I do basically is, > n put results ORDER BY into a temp table and > n add an autonum row > then you can work/select the data however you want > Fritz > > Von: [email protected] [mailto:[email protected]] Im Auftrag von Michael J. > Sinclair > Gesendet: Freitag, 26. Dezember 2014 18:01 > An: RBASE-L Mailing List > Betreff: [RBASE-L] - Selecting a row using count and order by DESC > > Hi All, > I am trying to select values from a row based on count. It seems to work as > expected when the order is ascending, but nothing changes when I make the > order descending. > > ColA ColB > ------------------- > abc 1 > def 2 > ghi 3 > > When I do this.... > > SELECT ColA into vdata i1 from table where count =1 order by ColB ASC > then I get the variable > vdata = abc > > When I do this.... > > SELECT ColA into vdata from table where count =1 order by ColB DESC *(changed > ASC to DESC) > then I still get > vdata = abc > > What I want is to get when the order is DESC > vdata = ghi > > What am I doing wrong? > Is what I want possible? > Mike >
