Exercise · SQL & Querying
Predict, then run it
Predict the output
entries(name, score) = Ana 90, Ben 90, Cy 80. Ties should share a place:
SELECT name, RANK() OVER (ORDER BY score DESC) AS place FROM entries ORDER BY name;
Predict the exact output.
entries(name, score) = Ana 90, Ben 90, Cy 80. Ties should share a place:
SELECT name, RANK() OVER (ORDER BY score DESC) AS place FROM entries ORDER BY name;
Predict the exact output.