name money
-----------------------------
a 100
b 30
c 50
d 120
e 80
查询条件 : 80正确的结果如下
name money
-----------------------------
b 30
c 50
e 80
-----------------------------
a 100
b 30
c 50
d 120
e 80
查询条件 : 80正确的结果如下
name money
-----------------------------
b 30
c 50
e 80
-----------------------------
a 100
b 30
c 50
e 80
查询条件 : 110
(
select 'a' name, 100 money
from dual
union all
select 'b', 30
from dual
union all
select 'c', 50
from dual
union all
select 'd', 120
from dual
union all
select 'e', 80
from dual
)
select * from a where money<=&money;
where money <= 80
order by money desc;
楼主是不是想排序啊……
where money <= 80
order by money desc;
(
select 'a' name, 100 money
from dual
union all
select 'b', 30
from dual
union all
select 'c', 50
from dual
union all
select 'd', 120
from dual
union all
select 'e', 80
from dual
)
select * from a where money<=&money;&自定义的变量
group by name having sum(money) < '&x';
你只关注他后面的select语句就行。
as()内的SQL如何才是动态的