基本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)
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)