select top 12 * from firm_bx where f_id>(
select max(f_id) from (
select top 7188 f_id from firm_bx where firm_name like '%北京%' or firm_name1 like '%北京%' or register_address like '%北京%' or register_address1 like '%北京%' or register_postalcode like '%北京%' or address like '%北京%' or address1 like '%北京%' or postcode like '%北京%' or leader like '%北京%' or contactman like '%北京%' or tele like '%北京%' or fax like '%北京%' or email like '%北京%' Order By f_id asc
) as a
)
and
(firm_name like '%北京%' or firm_name1 like '%北京%' or register_address like '%北京%' or register_address1 like '%北京%' or register_postalcode like '%北京%' or address like '%北京%' or address1 like '%北京%' or postcode like '%北京%' or leader like '%北京%' or contactman like '%北京%' or tele like '%北京%' or fax like '%北京%' or email like '%北京%')
Order By f_id asc
select max(f_id) from (
select top 7188 f_id from firm_bx where firm_name like '%北京%' or firm_name1 like '%北京%' or register_address like '%北京%' or register_address1 like '%北京%' or register_postalcode like '%北京%' or address like '%北京%' or address1 like '%北京%' or postcode like '%北京%' or leader like '%北京%' or contactman like '%北京%' or tele like '%北京%' or fax like '%北京%' or email like '%北京%' Order By f_id asc
) as a
)
and
(firm_name like '%北京%' or firm_name1 like '%北京%' or register_address like '%北京%' or register_address1 like '%北京%' or register_postalcode like '%北京%' or address like '%北京%' or address1 like '%北京%' or postcode like '%北京%' or leader like '%北京%' or contactman like '%北京%' or tele like '%北京%' or fax like '%北京%' or email like '%北京%')
Order By f_id asc
我把我sql语句贴出:select top 12 * from firm_bx where f_id>(
select max(f_id) from (
select top 7188 f_id from firm_bx where firm_name like '%北京%' or firm_name1 like '%北京%' or register_address like '%北京%' or register_address1 like '%北京%' or register_postalcode like '%北京%' or address like '%北京%' or address1 like '%北京%' or postcode like '%北京%' or leader like '%北京%' or contactman like '%北京%' or tele like '%北京%' or fax like '%北京%' or email like '%北京%' Order By f_id asc
) as a
)
and
(firm_name like '%北京%' or firm_name1 like '%北京%' or register_address like '%北京%' or register_address1 like '%北京%' or register_postalcode like '%北京%' or address like '%北京%' or address1 like '%北京%' or postcode like '%北京%' or leader like '%北京%' or contactman like '%北京%' or tele like '%北京%' or fax like '%北京%' or email like '%北京%')
Order By f_id asc
firm_name+register_address like '%北京%'
与
firm_name like '%北京%' or register_address like '%北京%'
是不一样吗?查出来的结果不一样