If you want to count something inside a group (something the same as auto_increment from mysql), you can use row_number
ROW_NUMBER ()
OVER (PARTITION BY ur_prnt_uid_id ORDER BY ur_chld_uid_id)
Rownum quiz
-
Here’s a silly little puzzle that baffled me for a few moments until I
spotted my typing error. It starts with a small table I’d created to hold a
few rows...
Acum 3 zile
Niciun comentariu:
Trimiteți un comentariu