Remove rows with duplicate value for a column in SQL [closed]












0

















From the above table, I want to remove the rows that have the duplicate CODE column. Out of the duplicate rows, the row with the smallest ID_CHECK should be retained.



Output:








sql







share|improve this question















closed as unclear what you're asking by Gordon Linoff, Shree, ewolden, Suraj Rao, AdrianHHH Nov 19 '18 at 12:22


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.














  • 2





    What is the DBMS you are using?

    – Mayank Porwal
    Nov 19 '18 at 11:43
















0

















From the above table, I want to remove the rows that have the duplicate CODE column. Out of the duplicate rows, the row with the smallest ID_CHECK should be retained.



Output:








sql







share|improve this question















closed as unclear what you're asking by Gordon Linoff, Shree, ewolden, Suraj Rao, AdrianHHH Nov 19 '18 at 12:22


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.














  • 2





    What is the DBMS you are using?

    – Mayank Porwal
    Nov 19 '18 at 11:43














0












0








0










From the above table, I want to remove the rows that have the duplicate CODE column. Out of the duplicate rows, the row with the smallest ID_CHECK should be retained.



Output:








sql







share|improve this question


















From the above table, I want to remove the rows that have the duplicate CODE column. Out of the duplicate rows, the row with the smallest ID_CHECK should be retained.



Output:








sql




sql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 19 '18 at 12:06









adiga

9,06462242




9,06462242










asked Nov 19 '18 at 11:30









Trinh PhamTrinh Pham

32




32




closed as unclear what you're asking by Gordon Linoff, Shree, ewolden, Suraj Rao, AdrianHHH Nov 19 '18 at 12:22


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.









closed as unclear what you're asking by Gordon Linoff, Shree, ewolden, Suraj Rao, AdrianHHH Nov 19 '18 at 12:22


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.










  • 2





    What is the DBMS you are using?

    – Mayank Porwal
    Nov 19 '18 at 11:43














  • 2





    What is the DBMS you are using?

    – Mayank Porwal
    Nov 19 '18 at 11:43








2




2





What is the DBMS you are using?

– Mayank Porwal
Nov 19 '18 at 11:43





What is the DBMS you are using?

– Mayank Porwal
Nov 19 '18 at 11:43












1 Answer
1






active

oldest

votes


















1














If I understand correctly, this should be your SQL query:



Select Names, Code, ID_CHECK

FROM

(

Select Names, Code, ID_CHECK, 

ROW_NUMBER() OVER(Partition by Name,Code Order By ID_CHECK) as rnk

FROM table

)tmp

WHERE tmp.rnk=1;


Let me know if this works.






share|improve this answer
























  • Please check what output OP pasted. This is what my query also produces. Also, he wanted to remove duplicates, which does not mean he wants a DELETE command.

    – Mayank Porwal
    Nov 19 '18 at 12:27






  • 1





    Thanks you @MayankPorwal , It is sure , Thank for your help .

    – Trinh Pham
    Nov 20 '18 at 2:25


















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









1














If I understand correctly, this should be your SQL query:



Select Names, Code, ID_CHECK

FROM

(

Select Names, Code, ID_CHECK, 

ROW_NUMBER() OVER(Partition by Name,Code Order By ID_CHECK) as rnk

FROM table

)tmp

WHERE tmp.rnk=1;


Let me know if this works.






share|improve this answer
























  • Please check what output OP pasted. This is what my query also produces. Also, he wanted to remove duplicates, which does not mean he wants a DELETE command.

    – Mayank Porwal
    Nov 19 '18 at 12:27






  • 1





    Thanks you @MayankPorwal , It is sure , Thank for your help .

    – Trinh Pham
    Nov 20 '18 at 2:25
















1














If I understand correctly, this should be your SQL query:



Select Names, Code, ID_CHECK

FROM

(

Select Names, Code, ID_CHECK, 

ROW_NUMBER() OVER(Partition by Name,Code Order By ID_CHECK) as rnk

FROM table

)tmp

WHERE tmp.rnk=1;


Let me know if this works.






share|improve this answer
























  • Please check what output OP pasted. This is what my query also produces. Also, he wanted to remove duplicates, which does not mean he wants a DELETE command.

    – Mayank Porwal
    Nov 19 '18 at 12:27






  • 1





    Thanks you @MayankPorwal , It is sure , Thank for your help .

    – Trinh Pham
    Nov 20 '18 at 2:25














1












1








1







If I understand correctly, this should be your SQL query:



Select Names, Code, ID_CHECK

FROM

(

Select Names, Code, ID_CHECK, 

ROW_NUMBER() OVER(Partition by Name,Code Order By ID_CHECK) as rnk

FROM table

)tmp

WHERE tmp.rnk=1;


Let me know if this works.






share|improve this answer













If I understand correctly, this should be your SQL query:



Select Names, Code, ID_CHECK

FROM

(

Select Names, Code, ID_CHECK, 

ROW_NUMBER() OVER(Partition by Name,Code Order By ID_CHECK) as rnk

FROM table

)tmp

WHERE tmp.rnk=1;


Let me know if this works.







share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 19 '18 at 11:42









Mayank PorwalMayank Porwal

4,9202724




4,9202724













  • Please check what output OP pasted. This is what my query also produces. Also, he wanted to remove duplicates, which does not mean he wants a DELETE command.

    – Mayank Porwal
    Nov 19 '18 at 12:27






  • 1





    Thanks you @MayankPorwal , It is sure , Thank for your help .

    – Trinh Pham
    Nov 20 '18 at 2:25



















  • Please check what output OP pasted. This is what my query also produces. Also, he wanted to remove duplicates, which does not mean he wants a DELETE command.

    – Mayank Porwal
    Nov 19 '18 at 12:27






  • 1





    Thanks you @MayankPorwal , It is sure , Thank for your help .

    – Trinh Pham
    Nov 20 '18 at 2:25

















Please check what output OP pasted. This is what my query also produces. Also, he wanted to remove duplicates, which does not mean he wants a DELETE command.

– Mayank Porwal
Nov 19 '18 at 12:27





Please check what output OP pasted. This is what my query also produces. Also, he wanted to remove duplicates, which does not mean he wants a DELETE command.

– Mayank Porwal
Nov 19 '18 at 12:27




1




1





Thanks you @MayankPorwal , It is sure , Thank for your help .

– Trinh Pham
Nov 20 '18 at 2:25





Thanks you @MayankPorwal , It is sure , Thank for your help .

– Trinh Pham
Nov 20 '18 at 2:25





-

這個網誌中的熱門文章

Xamarin.form Move up view when keyboard appear

圖片
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I'm trying to build a Chat app UI, the idea of the Layout was pretty simple: When the input bar is focused, keyboard show up and "push" up the chat bar, as it's a grid, the ListView will resize to fit the screen: I update the input bar's margin to "push" it up: NSValue result = (NSValue)args.Notification.UserInfo.ObjectForKey(new NSString(UIKeyboard.FrameEndUserInfoKey)); CGSize keyboardSize = result.RectangleFValue.Size; if (Element != null){ Element.Margin = new Thickness(0, 0, 0,keyboardSize.Height); //push the entry up to keyboard height when keyboard is activated } And this is ...
閱讀完整內容

Post-Redirect-Get with Spring WebFlux and Thymeleaf

圖片
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 2 Can someone explain to me how to implement the post-redirect-get pattern in Spring WebFlux and Thymeleaf? What subscribes on the database save method? @GetMapping("/register") public String showRegisterForm(Model model) { model.addAttribute("user", new User()); return "register"; } @PostMapping public String processRegisterForm(@Valid User user, BindingResult bindingResult) { if (bindingResult.hasErrors()) { return "register"; } else { userRepository.save(user); //what subscribes on this? //how to redirect on e.g. "/login"? ...
閱讀完整內容

Anylogic : not able to use stopDelay()

圖片
-2 I am building a railway station model. I want a train to depart when I click a button. I want to call stopDelay() for that but I am not sure how to do that and from which place. anylogic share | improve this question asked Nov 23 '18 at 10:12 Anupam Singh Anupam Singh 1 Hi Anupam, welcome to SOF. Please check how to ask good questions, see link below. Your question is...
閱讀完整內容