select top 10 * from View_Pz_ListNet where Pz_ID not in(select top 20 Pz_ID from View_Pz_ListNet ) 这种方式较理解
select top 10 * from View_Pz_ListNet where Pz_ID not in(select top 20 Pz_ID from View_Pz_ListNet ) ---------------------------------------------------------- 以上只能取第20条后的记录 select top 10 * from View_Pz_ListNet where Pz_ID not in(select top 10 Pz_ID from View_Pz_ListNet )
楼主是要10到20之间的数据吗?那么就是编号11-19总共九条数据, 我用SQL中自带的Northwind数据库的products表测试了下,下面这条语句应该可以: select top 9 *from products where productid not in (select top 12 productid from products)如果是编号10-20总共11条数据那么下面这条语句应该可以: select top 11 *from products where productid not in (select top 11 productid from products)
DatSet.Table[0].Rows[i]
DataTable DataTable2 = DataTable1.Copy();
DataTable2.Rows.Clear();
for(int i=10;i<=20;i++)
{
DataTable2.Rows.Add(DataTable1.Rows[i];
}
DataTable2.AcceptChanges();注意new一下
这种方式较理解
以上只能取第20条后的记录
select top 10 * from View_Pz_ListNet where Pz_ID not in(select top 10 Pz_ID from View_Pz_ListNet )
DataTable2.Rows.Clear();
for(int i=10;i<=20;i++)
{
DataTable2.Rows.Add(DataTable1.Rows[i].ItemArray());
}
DataTable2.AcceptChanges();
DataTable2.Rows.Clear();
for(int i=10;i <=20;i++)
{
DataTable2.Rows.Add(DataTable1.Rows[i].ItemArray());
}
DataTable2.AcceptChanges();
-------
这个可以
http://msdn2.microsoft.com/zh-cn/library/tx1c9c2f.aspx
DataSet里放多点数据,从DataSet里取好了
我用SQL中自带的Northwind数据库的products表测试了下,下面这条语句应该可以:
select top 9 *from products where productid not in
(select top 12 productid from products)如果是编号10-20总共11条数据那么下面这条语句应该可以:
select top 11 *from products where productid not in
(select top 11 productid from products)
* from 表名 where 主键 not in(select top 20 主键 from 表名)