摘要:
查詢重復列:select * from tb_user where tb_namein (select tb_name from tb_user group by tb_name having count(tb_name)>1)刪除數據庫中部分字段重復的記錄并保留一行。 --創建視圖create view v1 asselect *,row_number() over (order by serialcode) as 'id' from TMP_CQ_Cmn_Historywhere starttime in (select starttime from TMP_CQ_C 閱讀全文
posted @ 2011-06-29 13:45
Xingsoft
閱讀(190)
評論(0)
推薦(0)

浙公網安備 33010602011771號