語法如下,替換粗體字即可。
select column_name from database_name..table_name
where column_name in
(select column_name from database_name..table_name
WHERE cretaria like '%%'
group by column_name having count(*)>1)
order by column_name
select column_name from database_name..table_name
where column_name in
(select column_name from database_name..table_name
WHERE cretaria like '%%'
group by column_name having count(*)>1)
order by column_name