All pastes #757499 Raw Edit

hali

public sql v1 · immutable
·published 2007-11-01 12:06 UTC
rendered paste body
SQL> select * from t order by a;A----------AtestBtestDtestEtestHtestWtestdtest7 rows selected.SQL> with data as (select ascii(upper(substr(a,1,1))) a_val,a from t) select * from data where a_val>67 order by a;     A_VAL A---------- ----------        68 Dtest        69 Etest        72 Htest        87 Wtest        68 dtestSQL>