SET search_path TO test, public;
SELECT name,
percent,
@curRank := @curRank + 1 AS rank
FROM students s, (SELECT @curRank := 0) r
ORDER BY percent desc;
SELECT name,
percent,
dense_rank() over (order by percent desc) rating
FROM students
ORDER BY 1;
pow(x, y[, z])
Return x to the power y; if z is present, return x to the power y, modulo z (computed more efficiently than pow(x, y) % z). The two-argument form pow(x, y) is equivalent to using the power operator: x**y.
message = message.replace(char, out_chars[index])
- этот код повторно заменит d (т.е. b -> d -> #).message.translate(string.maketrans(from, to))
"./source/js/libs/jquery-3.5.1.min.js",
получается что то вроде Продам участок - 35
SELECT prof.id_prof, prof.name, COUNT(id_per)
FROM per
JOIN prof ON (per.id_prof = prof.id_prof)
GROUP BY 1, 2;
pass[y] = rand() % 10;
- вставляем непечатные символы. Наверно хотели pass[y] = rand() % 10+0x30;
?pass[d] = '\0';
Vasya(pass);