22,209
社区成员
发帖
与我相关
我的任务
分享
select identITy(int,1,1)as id , blog_name, blog_url as url ,UserName,WebName ,TypeInfo
into #temp
from bloginfo
where webname='百度'
select blog_name, blog_url as url ,UserName,WebName ,TypeInfo
from #temp id>10 and id<=20
where
select blog_name, blog_url as url ,UserName,WebName ,TypeInfo
from
(select row_number() over(order by blog_name) as num,blog_name, blog_url as url ,UserName,WebName ,TypeInfo
from bloginfo
where webname='百度')
where num>10 and num<=20
select blog_name, blog_url as url ,UserName,WebName ,TypeInfo
from
(select row_number() over(order by blog_name) as count,blog_name, blog_url as url ,UserName,WebName ,TypeInfo
from bloginfo
where webname='百度')
where num>10 and num<=20
--TRY
NOT IN -->EXISTS
create view view1 as
select blog_name, blog_url as url ,UserName,WebName ,TypeInfo,count(*) as counts
from bloginfo
where webname='百度'
group by blog_name, blog_url ,UserName,WebName ,TypeInfo
Go
create proc proc1 @FROM int, @TO int as
begin
IF @FROM>@TO or @FROM<0
RETURN -1;
select * FROM
(
select top @TO-@FROM+1 * FROM
(
select top @TO * from view1
order by counts desc
) t1
ORDER BY counts asc
) t2
ORDER BY counts desc
end