查询以消除错误的行 [英] Query to eliminate dulicate rows

问题描述

有谁知道以下服装的查询，


我有一张桌子，其中我有多行相同的条目。我想只保留这些行的一个副本。如何编写一个查询来删除所有重复的行，并且只有一个条目用于单个查询???


例如

Hi,

Do anyone know a query for the following senario,

I have a table in which i have multiple rows with the same entry. I want to keep only one copy of such rows. How to write a query to delete all the duplicate rows and have only one entry for such with a single query???

For example

展开 < span class =codeDivider> | 选择 | Wrap | Line数字

推荐答案

任何人知道以下senario的查询，


我有一个表，其中我有多个行具有相同的条目。我想只保留这些行的一个副本。如何编写一个查询来删除所有重复的行，并且只有一个条目用于单个查询???


例如


创建表员工

{

empno char（5），

名称varchar2（20），

薪水数字（5,2）

};


表的内容是


emp01 ranjit 10000.50

emp01 ranjit 10000.50

emp01 ranjit 10000.50

emp01 ranjit 10000.50

emp01 ranjit 10000.50

emp01 ranjit 10000.50

如何删除上表中的重复条目????

Hi,

Do anyone know a query for the following senario,

I have a table in which i have multiple rows with the same entry. I want to keep only one copy of such rows. How to write a query to delete all the duplicate rows and have only one entry for such with a single query???

For example

create table Employee
{
empno char(5),
name varchar2(20),
salary number(5,2)
};

the content of the table is

emp01 ranjit 10000.50
emp01 ranjit 10000.50
emp01 ranjit 10000.50
emp01 ranjit 10000.50
emp01 ranjit 10000.50
emp01 ranjit 10000.50

how to delete the duplicate entries in the above table ????

尝试行数不止一个的地方删除额外的行....

Try where the row count is more than one delete the extra rows....

有人知道以下参议员的查询，


我有一张桌子，我有一张桌子具有相同条目的多行。我想只保留这些行的一个副本。如何编写一个查询来删除所有重复的行，并且只有一个条目用于单个查询???


例如


创建表员工

{

empno char（5），

名称varchar2（20），

薪水数字（5,2）

};


表的内容是


emp01 ranjit 10000.50

emp01 ranjit 10000.50

emp01 ranjit 10000.50

emp01 ranjit 10000.50

emp01 ranjit 10000.50

emp01 ranjit 10000.50

如何删除上表中的重复条目????

Hi,

Do anyone know a query for the following senario,

I have a table in which i have multiple rows with the same entry. I want to keep only one copy of such rows. How to write a query to delete all the duplicate rows and have only one entry for such with a single query???

For example

create table Employee
{
empno char(5),
name varchar2(20),
salary number(5,2)
};

the content of the table is

emp01 ranjit 10000.50
emp01 ranjit 10000.50
emp01 ranjit 10000.50
emp01 ranjit 10000.50
emp01 ranjit 10000.50
emp01 ranjit 10000.50

how to delete the duplicate entries in the above table ????

您是否尝试过使用

Have you tried using

展开 | 选择 | Wrap | 行号

你可以使用以下查询。

Hi, You can use the follwoing query.

展开 | 选择 | Wrap | 行号

这篇关于查询以消除错误的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！