select *, row_number() over (order by cid desc) as num from items select * from (select *, row_number() over (order by cid desc) as RowNum from items) t2 where t2.RowNum=5 ...
-- vim:ts=2:sts=2:sw=2:et:filetype=sql -- For a script that auto-generates this SQL for all datasets in the current project, see -- bigquery_generate_query_biggest ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback