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
