topic HOW TO FIND SECOND HIGHEST SCORE IN EACH GROUP BY USING SQL in SAS Programming

topic HOW TO FIND SECOND HIGHEST SCORE IN EACH GROUP BY USING SQL in SAS Programming https://communities.sas.com/t5/SAS-Programming/HOW-TO-FIND-SECOND-HIGHEST-SCORE-IN-EACH-GROUP-BY-USING-SQL/m-p/481060#M124390 <P>ID       SCORE</P><P>111         450</P><P>111         620</P><P>111         300</P><P>222         458</P><P>222         958</P><P>222         300</P> Wed, 25 Jul 2018 09:19:59 GMT thanikondharish 2018-07-25T09:19:59Z HOW TO FIND SECOND HIGHEST SCORE IN EACH GROUP BY USING SQL https://communities.sas.com/t5/SAS-Programming/HOW-TO-FIND-SECOND-HIGHEST-SCORE-IN-EACH-GROUP-BY-USING-SQL/m-p/481060#M124390 <P>ID       SCORE</P><P>111         450</P><P>111         620</P><P>111         300</P><P>222         458</P><P>222         958</P><P>222         300</P> Wed, 25 Jul 2018 09:19:59 GMT https://communities.sas.com/t5/SAS-Programming/HOW-TO-FIND-SECOND-HIGHEST-SCORE-IN-EACH-GROUP-BY-USING-SQL/m-p/481060#M124390 thanikondharish 2018-07-25T09:19:59Z Re: HOW TO FIND SECOND HIGHEST SCORE IN EACH GROUP BY USING SQL https://communities.sas.com/t5/SAS-Programming/HOW-TO-FIND-SECOND-HIGHEST-SCORE-IN-EACH-GROUP-BY-USING-SQL/m-p/481064#M124392 <P>Marked as spam as the <A href="https://communities.sas.com/t5/Base-SAS-Programming/how-to-find-second-highest-score-in-each-group-by-proc-sql/td-p/481033/jump-to/first-unread-message" target="_self">same question</A> has already been asked.</P> Wed, 25 Jul 2018 09:24:37 GMT https://communities.sas.com/t5/SAS-Programming/HOW-TO-FIND-SECOND-HIGHEST-SCORE-IN-EACH-GROUP-BY-USING-SQL/m-p/481064#M124392 ChrisNZ 2018-07-25T09:24:37Z