第2个回答 2013-08-06
select TOP PAGE FIELDS from TABLE_NAME where THIS_TABLE.ID not in ( select top NUMBER_OF_PAGE * (PAGE -1 ) THIS_TABLE.ID from TABLE_NAME where XXX= ? and YYY like %?% and BBB isnull order by XXX ) and XXX= ? and YYY like %?% and BBB isnull order by XXX