Toad World® Forums

Order by not sorting data


#1

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 :frowning: and purchasing the full license for the business I work for hinges on resolving this issue

Syntax-example

CREATE TABLE tempq AS

select DISTINCT DEVICE,

Sess,

ROW_NUMBER() OVER (ORDER BY varchar,int8) AS ROW_NUMBER

from MQSALESbase1

WHERE DEVICE_ID = ‘var char’

group by varchar, int8

order BY min( int8 ) desc ;