Click here to Skip to main content

15,893,790 members

Sign in

Sign in

Email

Password

Forgot your password?

Sign in with

home
articles
quick answersQ&A
discussionsforums
featuresfeatures
communitylounge
help?

Search within:
Articles
Quick Answers
Messages

Use my saved content filters

All Questions All Unanswered FAQ

how to find and save the duplicate values in same table?

Please Sign up or sign in to vote.

0.00/5 (No votes)

See more:

how to find and save the duplicate values in same table?

Posted 24-Feb-14 20:31pm

Sai Prasad anumolu

Updated 24-Feb-14 21:06pm

v5

Comments

Kornfeld Eliyahu Peter 25-Feb-14 2:32am

Have you done anything so far? Show some effort (code or searching)! As is it ain't a question...

Sai Prasad anumolu 25-Feb-14 2:34am

hey this is qustion .....What r u doing .....Do not involve my communication

Kornfeld Eliyahu Peter 25-Feb-14 2:55am

That way you communicating no-one...
If you can't provide more details you probably will not get any answers!

Sai Prasad anumolu 25-Feb-14 2:58am

actually , You are Option ...Not question , So, I am very confusing, Please , U will not mention not question ....sir ..Y because i have so many douts in .net

♥…ЯҠ…♥ 25-Feb-14 3:02am

Using SQL Insert command ;-),I reckon you do not want this sort of answers, so try to put your question clear as much as you can

Sai Prasad anumolu 25-Feb-14 3:05am

my Question is .. ..Data is saving in database ..How to find Duplicate records in table ?

♥…ЯҠ…♥ 25-Feb-14 3:11am

So you do not want to insert duplicate records again and again, so only thing we need is code snippet from you.
You are inserting through SP or native query? try to post your code (we wont sell your code to anyone ;-))

Sai Prasad anumolu 25-Feb-14 3:18am

k sir , i will give clear explanation ...This is heavey code , My task is

When i was click save button Data is saving in database ---

<asp:Button ID="btnSave" Text="Save" Visible="true" OnClick="btnSave_Click" CssClass="btnCommon" runat="server" />

After click Save Button - Then i will click Duplicate button Display save record and
1 record is one option and
Duplicate is other option

<div>
<asp:Button ID="btnDuplicate" Visible="false" Text="Duplicate" OnClick="btnDuplicate_Click" CssClass="btnCommon" runat="server" />
<asp:Button ID="btnAddAnotherText" Visible="false" Text="Add another Text Add" OnClientClick="addStuff();" CssClass="btnCommon" runat="server" />

</div>

Duplicate is save Other record

♥…ЯҠ…♥ 25-Feb-14 3:55am

Still its unclear, you have two buttons, while clicking save button its saving in database, and when you click on duplicate button what is happening and what do you want to happen?

Sai Prasad anumolu 25-Feb-14 3:59am

When i click on duplicate button ..Display save data ...Okey but ,In duplicate button ..Edit and update options ..After i edit the data i click update data is updating sucussing ...Not saving other record .. I need to save other record

♥…ЯҠ…♥ 25-Feb-14 4:03am

Sort it out your requirement first and then try to put it here in crystal clear fashion, still its unclear for me. Can't even guess your requirement.
I hope Someone may help you out after reading your comments

Sai Prasad anumolu 25-Feb-14 4:06am

Thank you very much friend ...... Give me your email id

King Fisher 25-Feb-14 3:03am

not clear.

1 solution

Please Sign up or sign in to vote.

Solution 1

Accept Solution Reject Solution

Have a look at example:

SQL

DECLARE @tbl TABLE (ID INT IDENTITY(1,1), SomeData VARCHAR(30))

INSERT INTO @tbl (SomeData)
VALUES('a'),('b'),('c'),
    ('a'),('d'),('e'),
    ('d'),('b'),('f'),
    ('h'),('g'),('c')

--display all
SELECT ID, SomeData
FROM @tbl

--display duplicates
SELECT SomeData, COUNT(SomeData) AS CountOfSomeData
FROM @tbl
GROUP BY SomeData
HAVING COUNT(SomeData)>=1

For further information, please see:
Eliminating Duplicates with DISTINCT[^]
Find and/or Delete Duplicate Rows[^]
Find Duplicates using LINQ[^]

Note: you should provide more details about your issue, at least sample data and expected output.

Share this answer

Posted 24-Feb-14 21:19pm

Add a Solution

Add your solution here

Plain Text

ASM

ASP

ASP.NET

BASIC

BAT

C#

C++

COBOL

CoffeeScript

CSS

Dart

dbase

F#

FORTRAN

HTML

Java

Javascript

Kotlin

Lua

MIDL

MSIL

ObjectiveC

Pascal

PERL

PHP

PowerShell

Python

Razor

Ruby

Scala

Shell

SLN

SQL

Swift

T4

Terminal

TypeScript

VB

VBScript

XML

YAML

OKPaste as

Strip HTML

Encode HTML

Paste as-is

Code block

Quoted Text

Best guess

To display as

The content must be between 30 and 50000 characters.

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

Submit your solution

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Top Experts

Last 24hrs

This month

OriginalGriff	208
Pete O'Hanlon	95
Dave Kreskowiak	50
Richard Deeming	50
Richard MacCutchan	20

Pete O'Hanlon	700
OriginalGriff	498
Richard MacCutchan	245
merano99	120
Dave Kreskowiak	80

Related Questions

find duplicate value in table

How to duplicate this table multiple times and get the same results as the first table

Find duplicate entries in file and perform correct action

Find And Insert Duplicate Rows Into Temp Table from Two Tables

Finding Sql server table Duplicates

Find duplicate row in table SQL

Summing all values with same ID in a column give me duplicated values in SQL?

How to save checkbox value in DB and retrieve it later

Need to find the duplicate value

how find duplicate values from table according to name field ..

Advertise
Privacy
Cookies
Terms of Use
Last Updated 25 Feb 2014

Layout: fixed | fluid

Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900