0

More than 1 year has passed since last update.

@TomoJoz(Tomjoz)

BigQuerySQLで上から2行目だけを取得するコード

Posted at 2022-11-10

コード

offsetで指定した行数分だけ飛ばします
offset処理をした後にlimitします

select *
from table_name
order by column_name
limit 1
offset 1

参考文献

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0