Ah, i see. That's because the SQL Standard stinks. Methinks some people on the standards committee have never actually used the language.
Anyway, the ANSI 99 standard is pretty well supported, and can do just about anything, though perhaps not in the fastest method.
Ultimately, the best methods are specific to the RDBMS, do to what they were aiming for.
In reply to Re^5: poll ideas quest 2017 [The most hated language]
in thread poll ideas quest 2017 by pollsters
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>