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





-

這個網誌中的熱門文章

Tangent Lines Diagram Along Smooth Curve

圖片
7 1 I am trying to replicate a diagram and have a minimal example. I don't know how to add additional tangents between the specified points and preserve smoothness. documentclass{article} usepackage{tikz} usetikzlibrary{calc,intersections} begin{document} begin{tikzpicture} % Axes draw [->, name path=x] (-1,0) -- (11,0) node [right] {$x$}; draw [->] (0,-1) -- (0,6) node [above] {$y$}; % Origin node at (0,0) [below left] {$0$}; % Points coordinate (start) at (1,-0.8); coordinate (c1) at (3,3); coordinate (c2) at (5.5,1.5); coordinate (c3) at (8,4); coordinate (end) at (10.5,-0.8); % show the points foreach n in {start,c1,c2,c3,end} fill [black] (n) circle (2pt) node [below] {}; % join the coordinates draw [thick,name path=curve] (start) to[out=70,in=180] (c1) to[out=0,in=180]
閱讀完整內容

Yusuf al-Mu'taman ibn Hud

圖片
Main article: Taifa of Zaragoza Al-Mu'taman Ruler of Zaragoza Reign 1081–1085 Predecessor Ahmad al-Muqtadir Successor Al-Mustain II Born Zaragoza Died 1085 Full name Yusuf ibn Ahmad al-Mu'taman ibn Hūd House Banu Hud Yusuf ibn Ahmad al-Mu'taman ibn Hūd (Arabic: المؤتمن بالله يوسف إبن أحمد إبن هود ‎, al-Mutaman bi l-Lah , died c. 1085) was the third king of the Banu Hud dynasty who ruled over the Taifa of Zaragoza from 1081 to 1085. Yusuf al-Mutaman reigned during the height of power of Muslim Zaragoza , following the thriving period of his father Ahmad al-Muqtadir. He continued his father's efforts and created around him a court of intellectuals, living in the beautiful palace of Aljafería, nicknamed as "the palace of joy". Al-Mu'taman was also a scholarly king and a patron of science, philosophy and arts. As an example of a wise king, he knew astrology, philosophy, and especially mathematics, a discipline in which
閱讀完整內容

Zucchini

圖片
This article is about the vegetable. For other uses, see Zucchini (disambiguation). Zucchini (courgette) A striped and a uniform color zucchini Genus Cucurbita Species Cucurbita pepo Origin 19th century northern Italy The zucchini ( / z uː ˈ k iː n i / , American English) or courgette ( / k ʊər ˈ ʒ ɛ t / , British English) is a summer squash which can reach nearly 1 metre (100 cm; 39 in) in length, but is usually harvested when still immature at about 15 to 25 cm (6 to 10 in). [1] A zucchini is a thin-skinned cultivar of what in Britain and Ireland is referred to as a marrow. [2] [3] In South Africa, a zucchini is known as a baby marrow. Along with certain other squashes and pumpkins, the zucchini belongs to the species Cucurbita pepo . It can be dark or light green. A related hybrid, the golden zucchini, is a deep yellow or orange color. [4] In a culinary context, the zucchini is treated as a vegetable; it is usually cooked and presented as a savory dish o
閱讀完整內容