select top 15 cardnostart,cardnoend,cardnoaddtime,lastmodifytime,lastmodifypersion from gw_cardno_bin where id NOT IN (select top 75 id from gw_cardno_bin)
这段分页是成功的
我现在还想加一个限定条件就是模糊查询出cardnostart like %4*%
这样如何加到上面的分页查询中
select top 15 cardnostart,cardnoend,cardnoaddtime,lastmodifytime,lastmodifypersion from gw_cardno_bin where id NOT IN (select top 75 id from gw_cardno_bin)
这段分页是成功的
我现在还想加一个限定条件就是模糊查询出cardnostart like %4*%
这样如何加到上面的分页查询中
select top 15 cardnostart,cardnoend,cardnoaddtime,lastmodifytime,lastmodifypersion from gw_cardno_bin where id NOT IN (select top 75 id from gw_cardno_bin) [color=red]and cardnostart like %4*%[/color]