안녕하세요.
다음과 같은 테이블에서 금액이 3500일경우에
create table data (
id int identity(1,1),
minAmount int,
maxAmount int
)
insert into data(minAmount, maxAmount) values(0, 3000)
insert into data(minAmount, maxAmount) values(3001, 5000)
insert into data(minAmount, maxAmount) values(5001, 10000)
insert into data(minAmount, maxAmount) values(10001, 20000)
|