Samantha Carter
After being promoted to Major in Season 3 , Carter remains O'Neill's second-in-command until her promotion to lieutenant colonel early in Season 8 , at which point she assumes command of the SG-1 team and O'Neill is promoted to Brigadier General in order to lead Stargate Command . 
<triplet> Major <subj> lieutenant colonel <obj> followed by <triplet> Season 3 <subj> SG-1 <obj> part of the series <triplet> lieutenant colonel <subj> Major <obj> next lower rank <triplet> Season 8 <subj> SG-1 <obj> part of the series <triplet> SG-1 <subj> Season 3 <obj> has part <subj> Season 8 <obj> has part