HI, I have been utilizing SQL syntax for many years but have notice my data set will not sort with the order by function. my syntax is pretty simple and I have attempted the sort on
Order by Varchar;
Order by int8. along with countless other version of the order by statement and still it will not sort.
Although will correctly assign the order for the row number (smallest is 1 and largest 56).
Can anyone help me as I’m pulling my hair out a bit and purchasing the full license for the business I work for hinges on resolving this issue
CREATE TABLE tempq AS
select DISTINCT DEVICE,
ROW_NUMBER() OVER (ORDER BY varchar,int8) AS ROW_NUMBER
WHERE DEVICE_ID = ‘var char’
group by varchar, int8
order BY min( int8 ) desc ;