62,074
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
BearRui 2004-10-10
- 打赏
- 举报
SqlConnection cnn=new SqlConnection(".....");
SqlDataAdapter da=new SqlDataAdapter("Select * from table1",cnn);
DataSet ds=new DataSet();
da.Fill(ds,4,6,"tableName"); //从第4条记录开始向后取6条记录
SqlDataAdapter da=new SqlDataAdapter("Select * from table1",cnn);
DataSet ds=new DataSet();
da.Fill(ds,4,6,"tableName"); //从第4条记录开始向后取6条记录
ccbird 2004-10-10
- 打赏
- 举报
top只适用于SQL Server吧？
oracle里该怎么用呢？
谢谢
_jfeng 2004-10-10
- 打赏
- 举报
建议有顺序号，这样只需传入一个条件即可
penniless 2004-10-10
- 打赏
- 举报
not in (select top 3)
cancersyf 2004-10-10
- 打赏
- 举报
参考－－
SQL Tip of the day: get a specific range of results :
http://www.cnblogs.com/fengzhimei/archive/2004/08/10/31705.aspx
SQL Tip of the day: get a specific range of results :
http://www.cnblogs.com/fengzhimei/archive/2004/08/10/31705.aspx
china2001ok 2004-10-10
- 打赏
- 举报
6 应该改成10
china2001ok 2004-10-10
- 打赏
- 举报
oracle里可以这样写
mycom.CommandText ="select telnumber,begindate,enddate,ACCOUNTTYPE,USERNAME,PASSWORD from (select rownum id,l1.* from " +Session["temptable"]+ " l1 where rownum<=6) where id>=4 order by telnumber";
mycom.CommandText ="select telnumber,begindate,enddate,ACCOUNTTYPE,USERNAME,PASSWORD from (select rownum id,l1.* from " +Session["temptable"]+ " l1 where rownum<=6) where id>=4 order by telnumber";
goody9807 2004-10-10
- 打赏
- 举报
where 语句 加条件
