set schema mySchema
Select x,y,z from w
fetch first 20 rows only
reset an auto counter that got hosed
alter table T alter TheColumn restart with 123
grab the first non null value
select a,b,c, coalesce(z,y,z) as FirstGoodValue from T
select A, case when x < 0 then 'Negative' else 'Positive' end from T
TIMESTAMP format is 'YYYY-MM-DD-hh.mm.ss.uuuuuu'
get month from a date...