odbtools/odbctest/mql/basic/10basic/36between.mql

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/basic
/**
output()
count(5)
**/
;

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/basic where v_int between 1 and 5
/**
output()
count(5)
**/
;

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/basic where v_int between 1 and ?
/**
output()
params(1)
count(4)
**/
;

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/basic where v_int between ? and 5
/**
output()
params(5)
count(1)
**/
;

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/basic where v_int between ? and ?
/**
output()
params(1,5)
count(5)
**/
;