Xingsoft

摘要： 查詢重復列：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 閱讀全文