原来
http://topic.csdn.net/u/20100123/17/6a5c3107-88d0-4fe1-8879-e8ffb8885b5f.htmlselect Gift_PID,Products_Name_En,
convert(varchar,cast(Set_Points as money),1)as Set_Points,
if_FreeShipping,Products_List_Images,GiftsProducts_Hot,
If_Stock from
(select row=row_number() over(order by Products_Name_En),* from Gift_productsInfo) K
where row between 1 and 5 and CataLog_ID='101' and Switch='on' order by Products_Name_En -------------------这个是对的1-5行从第一行取出到底5行a
bf
bfsbfdbdf
cvwer
d
---------------------
select Gift_PID,Products_Name_En,
convert(varchar,cast(Set_Points as money),1)as Set_Points,
if_FreeShipping,Products_List_Images,GiftsProducts_Hot,
If_Stock from
(select row=row_number() over(order by Products_Name_En),* from Gift_productsInfo) K
where row between 6 and 10 and CataLog_ID='101' and Switch='on' order by Products_Name_En 怎么会取出只有3条呢???????????????????????????????6-10行也就是第二个5个
-----------------------------------
fedv
Gift Products Test Now Want three Days
hyt---------------------应该取出---fedv
Gift Products Test Now Want three Days
hyt
mjy
wef
create_name ----表结构
----------------
a
bf
bfsbfdbdf
cvwer
d
fedv
Gift Products Test Now Want three Days
hyt
mjy
wef
wf
http://topic.csdn.net/u/20100123/17/6a5c3107-88d0-4fe1-8879-e8ffb8885b5f.htmlselect Gift_PID,Products_Name_En,
convert(varchar,cast(Set_Points as money),1)as Set_Points,
if_FreeShipping,Products_List_Images,GiftsProducts_Hot,
If_Stock from
(select row=row_number() over(order by Products_Name_En),* from Gift_productsInfo) K
where row between 1 and 5 and CataLog_ID='101' and Switch='on' order by Products_Name_En -------------------这个是对的1-5行从第一行取出到底5行a
bf
bfsbfdbdf
cvwer
d
---------------------
select Gift_PID,Products_Name_En,
convert(varchar,cast(Set_Points as money),1)as Set_Points,
if_FreeShipping,Products_List_Images,GiftsProducts_Hot,
If_Stock from
(select row=row_number() over(order by Products_Name_En),* from Gift_productsInfo) K
where row between 6 and 10 and CataLog_ID='101' and Switch='on' order by Products_Name_En 怎么会取出只有3条呢???????????????????????????????6-10行也就是第二个5个
-----------------------------------
fedv
Gift Products Test Now Want three Days
hyt---------------------应该取出---fedv
Gift Products Test Now Want three Days
hyt
mjy
wef
create_name ----表结构
----------------
a
bf
bfsbfdbdf
cvwer
d
fedv
Gift Products Test Now Want three Days
hyt
mjy
wef
wf
Gift Products Test Now Want three Days
hyt
mjy
wef
----从第5行开始下面的5行阿6-15
convert(varchar,cast(Set_Points as money),1)as Set_Points,
if_FreeShipping,Products_List_Images,GiftsProducts_Hot,
If_Stock
from Gift_productsInfo K
where row between 6 and 10 and CataLog_ID='101' and Switch='on' order by Products_Name_En 的结果是什么?
-----------------------------------
fedv
Gift Products Test Now Want three Days
hyt
select Gift_PID,Products_Name_En,
convert(varchar,cast(Set_Points as money),1)as Set_Points,
if_FreeShipping,Products_List_Images,GiftsProducts_Hot,
If_Stock from
(select row=row_number() over(order by Set_Points),* from Gift_productsInfo) K
where row between 1 and 5 and CataLog_ID='101' and Switch='on'当我取1-5条的金额的时候只能取出4条
---------
100.00
101.00
102.00
199.00
数据库中符合条件的总共11条
------------------------
100.00
101.00
102.00
199.00
1,000.00
4,400.00
5,500.00
6,600.00
7,700.00
8,800.00
12,345.00
convert(varchar,cast(Set_Points as money),1)as Set_Points,
if_FreeShipping,Products_List_Images,GiftsProducts_Hot,
If_Stock from
(select row=row_number() over(order by Set_Points),* from Gift_productsInfo where CataLog_ID='101' and Switch='on' ) K
where row between 1 and 5
GO
/****** 对象: Table [dbo].[Gift_ProductsInfo] 脚本日期: 01/23/2010 19:38:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Gift_ProductsInfo](
[Gift_PID] [int] IDENTITY(1,1) NOT NULL,
[Gift_ProductsID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CataLog_ID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Products_Name_Cn] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Products_Name_En] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NOT NULL,
[In_Retail_Price] [money] NOT NULL,
[In_Retail_Price_Rate] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Set_Points] [money] NOT NULL,
[Prdoduct_Weight] [float] NOT NULL,
[Weight_Unit] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[GiftsProducts_Hot] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
[Products_BigImages] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[Products_List_Images] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[if_FreeShipping] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[Description] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL,
[Switch] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[StationID] [int] NOT NULL,
[Create_name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Create_Time] [datetime] NULL,
[If_Stock] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Gift_Products_Sum] [int] NULL,
[make_Time] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
是不是把条件放入重新查询的表中
(select row=row_number() over(order by Set_Points),* from Gift_productsInfo where CataLog_ID='101' and Switch='on' ) K
where row between 1 and 5