delete from tname where rowid<>(select max(rowid) from tname group by id,字段1)
bzszp 你好,你的方法可以实现,但是我查询出来的内容创建视图,我的语句如下: create view protein2_view as select min(id), protein_seq, name from protein2 group by name,protein_seq;运行出现如下错误: select min(id), protein_seq, name from protein2 * ERROR 位于第 2 行: ORA-00998: must name this expression with a column alias ----------------------------- 谢谢!
select min(id) minid,protein_seq, name from protein2...
create view protein2_view as
select min(id), protein_seq, name from protein2
group by name,protein_seq;运行出现如下错误:
select min(id), protein_seq, name from protein2
*
ERROR 位于第 2 行:
ORA-00998: must name this expression with a column alias
-----------------------------
谢谢!
开始撒分!:)