I'd like to get the sum of count(*) between several ranges
I'd like to get the sum of count() between several ranges. For example I
have 10 select count() statments from one location range to another. I'd
like to get the sum of all 10 location ranges. SELECT count (*) FROM
locn_hdr WHERE locn_brcd BETWEEN 'B2121' AND 'B2144' + SELECT count (*)
FROM locn_hdr WHERE locn_brcd BETWEEN 'B2201' AND 'B2224'
No comments:
Post a Comment