标题：在SQL中删除重复记录(多种方法)

时间：2005-8-23 来源：不详 浏览数：次

bsp;                         VARCHAR2(20)

salary                                                  NUMBER(10,2)

 

 

可以通过下面的语句查询重复的记录：

SQL> select * from employee;

 

    EMP_ID EMP_NAME                                  SALARY

---------- ---------------------------------------- ----------

         1 sunshine                                      10000

         1 sunshine                                      10000

         2 semon                                         20000

         2 semon                                         20000

         3 xyz                                           30000

         2 semon                                         20000

 

SQL> select distinct * from employee;

    EMP_ID EMP_NAME                                     SALARY

---------- ---------------------------------------- ----------

         1 sunshine                                      10000

        

上一页  [1] [2] [3] [4] [5] [6] [7] [8] 下一页

（责任编辑：欣欣裴）