查询重复记录:
取得表Fin_info中ASST_ID,data_date ,debt_code三个字段值相同的记录.
例子如下:
select t.*
from Fin_info t,
(Select ASST_ID, data_date, debt_code
From Fin_info
Group By ASST_ID, data_date, debt_code
Having Count(*) > 1) A
where t.ASST_ID = A.ASST_ID
and t.data_date = A.data_date
and t.debt_code = A.debt_code
and t.st_num <> '0'
order by t.ASST_ID, t.data_date, t.debt_code;
取得表Fin_info中ASST_ID,data_date ,debt_code三个字段值相同的记录.
例子如下:
select t.*
from Fin_info t,
(Select ASST_ID, data_date, debt_code
From Fin_info
Group By ASST_ID, data_date, debt_code
Having Count(*) > 1) A
where t.ASST_ID = A.ASST_ID
and t.data_date = A.data_date
and t.debt_code = A.debt_code
and t.st_num <> '0'
order by t.ASST_ID, t.data_date, t.debt_code;