这个表里就一个数据,我想根据这个percent的值判断大小,如果大于1就union all一张虚拟表,否则就只查这一条数据。这个怎么写啊
select * from casewhen ${if(sql("finedb","select * from casewhen",1,2)>1," union all select 2 from dual","")}
finedb 换成你对应的数据连接