select * from userid.temptzxx where scrq between '2003-01-01 ' and '2003-09-01 ' select * from userid.temptzxx where scrq > = '2003-01-01 ' and scrq <= '2003-09-01 '
