select A.Src , B.*,A.Name, D.Number ,C.Name, D.StatusID
from [Web_OrderProduct] as A
INNER JOIN [Web_OrderRefund] as B on A.OrderNumber=B.OrderNumber
INNER JOIN Web_Category AS C ON A.CategoryID=C.ID
INNER JOIN Web_Order as D on A.OrderNumber=D.Number
where D.IsOut=1 and D.UserName='123456'这个联合查询结果我想进行分页,各位亲们咋办啊?给个代码呗?
from [Web_OrderProduct] as A
INNER JOIN [Web_OrderRefund] as B on A.OrderNumber=B.OrderNumber
INNER JOIN Web_Category AS C ON A.CategoryID=C.ID
INNER JOIN Web_Order as D on A.OrderNumber=D.Number
where D.IsOut=1 and D.UserName='123456'这个联合查询结果我想进行分页,各位亲们咋办啊?给个代码呗?
解决方案 »
- 要用session控制某个具体的js,jpg,css等文件是否可以下传,有办法吗?
- 如何突破C#瓶颈呢?寻求帮助
- C#中使用PulseEvent对多线程同步的问题
- 如何用C#把int型的多个二维数组存储在文本文件里
- image数据类型的字段,在报表中如何让它正常显示出来.................
- 请问c#中不用第中间变量,能否对变量a,b进行值的交换?
- 问个关于用sendmessage click toolbar button的问题
- 如何比较XML???????
- 求字符串转Keys集合!
- 有谁做过 Form Designer 给点思路,和资料
- DataGridViewComboBoxColumn的使用问题
- SPEECH 无法读中文
@sql nvarchar(600)
set @sql=’select top’+str(@end-@start+1)+’+from T where rid not in(select top’+str(@str-1)+’Rid from T where Rid>-1)’
exec sp_executesql @sql
@sql nvarchar(600)
set @sql=’select top’+str(@end-@start+1)+’+from T where rid not in(select top’+str(@str-1)+’Rid from T where Rid>-1)’
exec sp_executesql @sql
这个是存储过程吧,嗯我想用sql语句查询数据库,谢谢再帮我想一个吧,拜托,拜托啦!
select * from (
select top 10 * from (
select top 20 * from dbo.RequestService order by id asc )a
order by id desc) b
order by id asc就是先取前20条,再倒序取前10条,把顺序再换回来所有的都可以这样弄