2010年2月22日
摘要: 选择: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)
摘要: 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 阅读(572) 评论(0) 推荐(0)