SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table tbl ( "group" int, "value" int ); insert into tbl values (1, 3),(1, 4),(1, 2),(1, 7),(1, 9),(1, 0),(1, 1), (2, 93),(2, 3),(2, 23),(2, 13),(2, 3),(2, 30),(2, 33),(2, 32),(2, 31); with ranked_data as ( select "group", "value", rank() over (partition by "group" order by "value" desc) from tbl ) select * from ranked_data where rank < 6;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear