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
