摘要: insert into<TableName1> (<column1>,<column2>) select<column1>,<column2> from<TableName2> where column1=1update <TableName1> set <column1,column2>= (select (<column1>,column2) from <TableName2> where TableName1.<column2> =TableName2.&l 阅读全文
posted @ 2013-04-18 16:35 Blue Studio 阅读(264) 评论(0) 推荐(0) 编辑
摘要: select count(A),A from table_Agroup by Ahaving count(A)>1 阅读全文
posted @ 2013-04-18 16:34 Blue Studio 阅读(587) 评论(0) 推荐(0) 编辑