sql 知识点杂技

一、ROW_NUMBER

语法：ROW_NUMBER ( ) OVER ( [ <partition_by_clause> ] <order_by_clause> )

事例：select row_number() over (order by dict_type_id) ,* from E3_DICT_TYPE