现有一张表za_page,结构按如下描述:
f_id int(11) primary key
f_description varchar(100)
其中f_id是主键,f_description是字符串,数据库中f_description会有重复的值,现在要求写一条SQL语句把那些f_description重复的记录找出来。
答:
select f_description, Count(*) from za_page
group by f_description
having Count(*) > 1