"Lloyd Thomas" <[EMAIL PROTECTED]> wrote: > if use > SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10; > I get 0 results
You DID specify a table in your actual queries, didn't you? select * from tbl; t x y ---------- ---------- ---------- 1 100 101 2 100 102 3 100 103 4 100 103 5 200 210 6 200 220 7 200 230 8 300 199 select count(t) from tbl where y=103; count(t) ---------- 2 select count(t) from tbl where y between 102 and 210; count(t) ---------- 5 Regards