oracle查询出两个重复书名:book,怎么让这个书名查出来是book1、book2,有多个重复的话序号自增
表结构: name
book
pen
book
paper
book
预期的结果 : name
book1
pen
book2
paper
book3
oracle查询出两个重复书名:book,怎么让这个书名查出来是book1、book2,有多个重复的话序号自增
表结构: name
book
pen
book
paper
book
预期的结果 : name
book1
pen
book2
paper
book3
select count(*) as cnt, name from table group by name having cnt > 1