删除行 [英] Delete the Row

问题描述

我创建了一个表，其中有人在两行中完全相等的条目中插入两行相同的行，因此我想删除其中的一行.
如何使用查询的帮助???????

I was Created a table.In which somebody insert two same rows in ie.exactly equal entries in two rows.So i want to delet one row of them.
how can i do it with the hepl of query??????
tell the condition in where cluse.

推荐答案

使用此查询:

Use this query :

delete top(1) from (tablename) where (condition)

在where条件中，放置一个条件，使得将仅选择这两个相同的记录.

In where condition, put a condition such that only those 2 same records will be selected.

你好，
它们在表中没有主键约束吗?如果是，则用户无法插入重复的条目.......

谢谢与问候
基数:)

hello,
Is their no primary key constraint in your table ? if their is then the user cannot insert duplicate entries..........

Thanks & Regards
Radix :)

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