D 2019-04-03T08:59:16.124 J icomment on\sfurther\sthought,\sthe\ssecond\sexample\swould\stranslate\smore\slike\sthis\sif\syou\swere\sto\suse\ssql\sserver\sEF6:\r\n\r\n
\r\nselect\s[all\scolumns\sexcept\srownum]\r\nfrom\s(\sselect\s*,\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\srow_number()\sover\s(partition\sby\scol1\sorder\sby\scol2)\srownum\r\n\s\s\s\s\s\s\sfrom\stable\s)\sx\r\nwhere\sx.rownum\s=\s1\r\n
J login anonymous J mimetype text/x-fossil-wiki K 8f05349da78773f4dfc29ace794ad174b909917b U anonymous Z 1868b22f5e23efc6a0c338b79d691064