Breaking News: Grepper is joining You.com. Read the official announcement!

sql select students closest in score

Kat answered on March 30, 2022 Popularity 1/10 Helpfulness 1/10

answer sql select students closest in score

sql select students closest in score

Comment

SELECT 
    s1.student AS one_student
    , s2.student AS other_student
    , ABS(s1.score - s2.score) AS score_diff
FROM scores AS s1
INNER JOIN scores AS s2
    ON s1.id != s2.id
        AND s1.id < s2.id
ORDER BY 3 ASC, 1 ASC
LIMIT 1

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.interviewquery.com

Tags: closest select sql

Link to this answer
Share Copy Link

Contributed on Mar 30 2022

Kat

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

sql select students closest in score

Contents

More Related Answers

sql select students closest in score

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.