Go to Qiita Advent Calendar 2024 Top

0

More than 1 year has passed since last update.

SQL チートシート

Last updated at 2023-05-19Posted at 2023-05-19

MOD: - 余剰を求める

引数２を引数１で割った余りを戻す。
modulo¹の略。

ROWNUM: - 行番号を求める

選択した行の番号を戻す。
ROWNUM=1 だと１行目。

参考：
https://docs.oracle.com/cd/E82638_01/sqlrf/MOD.html#GUID-E12A3928-2C50-45B0-B8C3-82432C751B8C
https://docs.oracle.com/cd/E16338_01/server.112/b56299/pseudocolumns009.htm

〜法。モジュロ演算。 ↩

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