Skip to content

[๐Ÿ’กQuestion] 8์ฃผ์ฐจ_p273_๋‹ค์ค‘ํ•„๋“œ๋น„๊ตย #91

@juhee77

Description

@juhee77

โ“์ด๋Ÿฐ ๋‚ด์šฉ์ด ๊ถ๊ธˆํ•ด์š”.

SELECT class, student id,
  (SELECT COUNT (*)
    FROM Weights2 W2
    WHERE (W2.class, W2.student_id)
    <= (W1 .class, W1.student_id) ) AS seq
FROM Weights2 W1;

ํ•ด๋‹น ์ฟผ๋ฆฌ์„ค๋ช…๊ณผ ํ•จ๊ป˜, ๋‹ค์ค‘ ํ•„๋“œ ๋น„๊ต ์ถ”๊ฐ€ ์˜ˆ์‹œ๊ฐ€ ์žˆ์œผ๋ฉด ์ข‹์„๊ฑฐ ๊ฐ™์Šต๋‹ˆ๋‹ค!

Metadata

Metadata

Assignees

Type

No type

Projects

Status

No status

Relationships

None yet

Development

No branches or pull requests

Issue actions