02 2010 档案
基本sql常用的语法,不经常用sql,备忘
摘要:选择:select * from table1 where 范围   插入:insert into table1(field1,field2) values(value1,value2)   删除:delete from table1 where 范围   更新:update table1 set field1=value1 where 范围   查找:select * from table1 w... 阅读全文
posted @ 2010-02-22 12:41 lbsx 阅读(190) 评论(0) 推荐(0)
sql从表中取出31到40条数据
摘要:select top 10 * from a where id not in (select top 30 id from a order by id) order by id关键字:topreference: http://www.ej38.com/showinfo/sql-113227.html 阅读全文
posted @ 2010-02-22 12:38 lbsx 阅读(573) 评论(0) 推荐(0)