Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Remove duplicate records

Home
Forums

Remove duplicate records

Manish Kumar

10yAsked Sep 13, 2016, 11:35 AM737

Hi All,

I have a table which has 2 columns lets say id1,id2 and data are like in below format

id1 id2

1 2

4 7

21 5

62 10

7 4

10 62

5 21

2 1

i want unique data in below output like

id1 id2

1 2

4 7

21 5

10 62

or its like

id1 id2

2 1

7 4

5 21

62 10

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Tapan Patel10y ago
Accepted answer
One of the good questions.
Here is how you need to do that.
SELECT DISTINCT
CASE WHEN id1>id2 THEN id2
WHEN id1 < id2 THEN id1
ELSE id1 END,
CASE WHEN id1THEN id2
WHEN id1>id2 THEN id1
ELSE id2 END
FROM YourTableName
Please mark it as an answer if it addresses the issue.
Tapan Patel10y ago
You're welcome Mr. Manish.
Manish Kumar10y ago
Thanks Tapan, It works and saved my lots of time.