Sinusoidal: original Transformer paper. Add fixed sin/cos of different frequencies to the token embedding before attention.
RoPE: rotate Q and K vectors by a position-dependent angle. The dot product naturally encodes relative position. Better extrapolation, used by Llama, Mistral, every modern LLM.