Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Remove duplicate records
Manish Kumar
Sep 13 2016 11:35 AM
259
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
how to find count of agent having sum(amount)>10000
how to give permission to user to change the schema name