select
m.adminusername,
m.admintypeid,
m.adminarea,
m.adminstate,
c.membertypename,
identity(int,1,1) r
into #
from
LDT_WEB_ADMIN m,
LDT_WEB_CLUBMEMBER c
where
m.admintypeid=c.MEMBERTYPEID and adminusername<>'admin'
select * from # where r between 1 and 10
m.adminusername,
m.admintypeid,
m.adminarea,
m.adminstate,
c.membertypename,
identity(int,1,1) r
into #
from
LDT_WEB_ADMIN m,
LDT_WEB_CLUBMEMBER c
where
m.admintypeid=c.MEMBERTYPEID and adminusername<>'admin'
select * from # where r between 1 and 10
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货