if i query just one table & restrict by date, then want a subset based on rownum, i get different results on 2 different dbs w/ same table defs & content (indeces are also the same). Is this b/c i order by after the rownum?
can't post the query (proprietary), but it's something like this:
select col1, col2 from tableA where col1 = '<value>' and rownum < <threashold> order by col1;
can't post the query (proprietary), but it's something like this:
select col1, col2 from tableA where col1 = '<value>' and rownum < <threashold> order by col1;