SQL Server数据库row_number() over() 来自动产生行号是本文我们主要要介绍的内容,接下来我们通过一个实例来了解一下这部分内容。实例如下:
需求:需要统计网站的访问量,具体是哪个用户的ip访问该网站,并统计从哪个连接访问该网站。
class='fit-image' onload='javascript:if(this.width>498)this.width=498;' onmousewheel = 'javascript:return big(this)' alt="SQL Server数据库row_number() over() 来自动产生行号" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAmMAAAEoCAIAAACb3WEYAAAgAElEQVR4nO2dzXLjOpbn+Ty1600GL9+g3qC3LTvYD1G72pXsG8FN7aqeYGYy5ZwI1qbfoaOcdm4UMf3dPbPqm7b1ad/QLCSSwDnAAUCBFmj+f4HIUIL4OgCIvwDIQHYYIX+4/eM/Jszz8/Mfbv/4CwAAgA9BdmnV68Mfbv8IBwcHBwf3Pm6USgkAAAC8G51S/o//9b/h4ODg4ODgiNOUclBNfnp6GjT9WMQt51isjs5kDfcE9ZMgaBRgA0pJgVJGYbKGe4L6SRA0CrDxfkr548ePQdOPRdxyjsXq6EzWcE9QPwmCRgE2PohSZhn9aRL38QRKGYXJGu4J6idB0CjAxsWVsi6zsj4cMjunglr826ckXYtSnrILK+eyKopqefygFMCRkC01WgZ3kazlSZhgwy2VLNRzXfq2QoJI3SwGx8rxqkfQAKUENt5PKX/55RfuuawK/v4K00GbQHJ/q7K6hMlQTnUQ78ayZVW4Bx+T1ZNQymDDzZUsGBtebykhdbPeGFJQamkM3eayGMcoAA7vqZT//d//zfzMg92ZSmmMrnga1VksZ/AgLqY2DaUMNtxWybb6GUMlCEjdrDeyUgIXpk4LwOFAlPL19W2z3Q/h3t5+/a//+/9o+nfX2dVXHjjLMls66hxRDUk+kBTIfxdX2dVdSDkff87znx/UDyf39Sq7XoRaTWOd/vtw+9PRrvz2+ynTk6E/3Twes76+yrMsu14ci9H5ZJlYjPd3AYarVhgrWa38rkK+XmWK4UJdXboqgrvZ4895/vNNY96xo3r3DaUaeZ2zbpPffr3J7cleupYu0igXHItBymhKuX99W292Q7i3t1//4z//i6T/7SbPb76vNzvjYqnKMXz7of1sfEQC8Edtvp7lXD/c5vntN/XDyX2f5/n8Iczq9eZull0v6H8bz4fbPLteqCkfM324zTOrz7ebPLu6G6jtYjW32fDWCrWStcY/RjFVyKktxLpK0knd7OE2z7LZQvHx7xu0f+p1zgNrsViyl66lizTKBcdikDLvpJS//vrrv//Hf9qUUnVEAm3+PkrJPYV8hXLalZIM/X6pmZXy+/z47f5YMKoW+XyhZE2loh1DLz/cBBvO61ar5O/zPJstxAqR6ypJJ3WzB9bQ/n3DUymNFc6TTfirxnCNcsGxGKSMrpT719V6O4R7+/XXf/v3/yTp38/zfP5IQmZZ1v5rdGqANpgaXpibCvkK5Vx9u83z23v1A/EPsXq1fpzn+fybOZEvsyzLrr58u82zqy/GMrSfuc8wbReruc2G87oltiyustndSqgQua6SdFI3szeru28YDL+btYHlCufJTswdG+WCYzFImUsq5WkQVHyMyscdD9YKpyC0reeXWTZbhJTTPBI9znNrOlJqpACdEhxV5CgnSuLHIcyolM3Qdj/PSU1e1oUZLivlaawXKkSsqyRdmFL6941zlJJX46Vr6SKNcsGxGKSMppS7/evLajOEe3v79V/+9d9Z+otZdvW5+W+WZS+uz/y/4WEe/pB3mXqV8/7mU35zf/ygzFBnX/pZfSxDu8p1c7/avKw29/OT16f5Q1M5pxB/uFfK0Jbn/uZTnn/SE0nEBRiu1i35oESZfRErRHqUopO6GW/ogL5x9Fe7t/KKkfQNFa4ne+laukijXHAsBimjKeV2t39+WQ/h3t5+/ed/+Tee/l//kP/d5/XzyzrLMtVf/a/tsy388b9Gnl/Wz59n2WwRWs64Vsdx9/NPn+Z/Haa9kjZ8/A71k6A7NsoFx2KQMrpSbvdPz6sh3Nvb2z/987+a0v/yd9ksyzIeRVW41kcIRjyNIY/Z/c8+5YxrdQz31/mnT/N/HKa9kjZ8/A71k6A7NsoFx2KQMppSbra7H08vQ7jXt7f/80//Mlz6aZZzLFYnXo0fz6F+EnTHRrngWAxSRlPKRwAAmDAXHItBypAzegZkv98Pmn4s4pZzLFZHZ7KGe4L6SZD9fn/BsRikjKaUvwAAwFS54EAMEocq5XA5jaUjxi3nWKyOzmQN9wT1kxpoESAApaRAKaMwWcM9Qf2kBloECEApKVDKKEzWcE9QP6mBFgECUEoKlDIKkzXcE9RPaqBFgICnUka4D1bsiAndN2srZ12ejjgIKqi/1Tz91seSpV5pLP6yKo4eluuBtehCYJZwVy5r2u8z7vS7+jiNK6Cd3cxQ3Vo34K+M+SXi0X3a2pX7yAK7XqXDAUoJRJxK2b5WAylltPRjYS5nXTbjSpio+1rN0l9WRfNQ+WiLfqjL5j+nlLpIXdLW6EJgg+FeNZCKUvIwCSulodG70rafeOvbXyIe3d7WPHepExpTpkVNI7AQXQFKCQQwp6S4XpiwgdbTajXRZVWQurBkqVSaUQ0bH0vlKt7uwAfTuCORilLGihUbZ/2ciqk3sr6G4DGn5NG92trjCwZP2VrUSwcWoitAKYEAVcrX17fNds/c16vsemHwD3AfRCn5BK9/akapW1ZFxr42O6TOFKId2Wx1q/o7Ayt5tBMYYe3VaLg271WmNVWgf5vnsiqKstSnU+rSsCYMSrGzolqS7ybUErZc10VvKqHJuqjqqnDUhlf9aHSzOksxvZTSFN2jrS3LGKoPT9mUF1fnWIEDiuFo6gYoJRCgSsnuqWc3p/d1H0Apj6PlwPuURVnSscAyButTUioZ7eBuGxn0OhcDa4broh7yDV0ZEjUZC/XXinUsgKEo2jCpPD+WXxo+1cTa0HpGbauoH0KkUh6XjalGUkpnx7B8WbOtekbSs+ECQynB+UApKZ5f9mOkZv0Jhvpi2wc0fU5J1Mu9N2NcfRVGEqsYGUMbDT9mWZdFVVfF6dOyh78he9OUt1PE3qOvMSM1Ov/gh+MLWZNUP6U8fesqa0N01tZtYJ67zUeuEl4ZUEowdphSsnvq6c3pfd1HUcqwITHcan36IuWkLd6Gjw7WXVJBKgUFIdh+GFVUVXkcnxv56+PPs++GfV1kxqaUtNFj71PKbe0pk+aCYZ8SfFyglBTfHyWekVqDaaOx3czrdvXc0ZXPTUruNVLrLinZjiJlZOuYQYbXZbPq1y6p9vK3FI4bxVZfm6Ff+D2U3+rrEErJG9063fdTSh5d6Bg8d6ET8pSFlYnLBvZaMoFSAgmqlLv968tqw9xill19NvgHuFEr5UH5jUfIeNj/7ynVX6Y0mZJaYnMM9ocnuo8UXQjMDfepCuHPY0zFCfWvy+Paol5BB33xVduPbB8URTt+ZrqP/tMhyy96bAIZQylNjc6LotQAjW1ezHd1DGvuxvKEpGzoRZcIbDVZBUoJBKhSbnf755f1EG4sHRFn9ERhsoZ7gvpJDbQIEGBKud0/Pa+GcGPpiFDKKEzWcE9QP6mBFgECVCk3292Pp5ch3Fg6IpQyCpM13BPUT2qgRYAAVcrHwRhLR4RSRmGyhnuC+kkNtAgQ4Gf0DMVYOiKUMgqTNdwT1E9qoEWAAFVKAACYJhcciEHi4H5KStxyjsXq6EzWcE9QP6mBFgECUEoKlDIKkzXcE9RPaqBFgACUkgKljMJkDfcE9ZMaaBEgAKWkQCmjMFnDPUH9pAZaBAi4ldLnICgfbB0xVvqxsJWTHGd2ZmqHw0E+ze7grhnHaXauArNT4yyBhWPyhMp4j3En8AC5s2LFxv91iH6anU9b89x50kGHxl02ME6zA2fiUMreJ4NzjB0xYvqxML8w2hHmAQOt5fVrByt+SHfd3mdrrxkWXTnK+pSSVGAWXQjMCuZ5SG8qShl0Aco74vs6GE735q3PfZQU+XHhlrY2HzhPW19MGSekgw9KwOrrmSOMsyOmMYLZlbIpXNBp7p5zSnIXEknfUjPCbRg+BVa8vazj445EKkoZK1ZsfF8H641RfnNKHt2vJ5O7xQ68WwZdbnXZwEJ0BSglEOAnD7xttnuT+36TZ1d3xkdeztUR055TdgNM2LUnvquv+l1I/IpAWepMIZwFVv09rGvzUG7rCLtLRJv3KtOaKtC/zXNZFUVZ6tMpdWlYEwZy8QgRAWqJ/S6RthKarIuqrgpHbXjVjwa93YsV00spTdF9ejKfU9JuyVM25cXVOVbggGI4mroBSgkE2P2Ur2/rzY67bzd5lt9+Mz3ydM4Ja9hIMxjWci57jIc99imLsqRjgSVPfUpKJcNZYH2gFAMfH3ZapIyeId/QlSFRk7FQf61YxwIYiqINk8rzunQppZpYbb2fMmsXMwOm2mL96CVgqUZSSndPVruc0C3j6tlwgaGU4Hy8lPJ8mZSVMh2ZPLhXX8NGRH+lVH3VF9teM/qckqiXu8DG1VfBOqsYGUPbfh1W1oe6LKq6Kk6flj38DdmbprydIvYefY0ZFfq1l+SDH56vQz+lPMlbWRuis7ZuA/PcSerpiF9QYCglOB+mlPvX1Xqruvt5nuW397pnDyf9pjQZmTzYf2rh87J5ptZgVEp9+iLlpC3eho8O1l1SQSoFBSGYDa/LoqrK4/jcyF8ff559N+zrIjM2paSNHnufUm5re5dj35OwTwmmhEspF1dZdvXlbJm0KmW3d5UK1nKSSds5qXWJso3GtkLcNaO+9e3nJiV3ga27pGpg5f/KuiNbh/U2vC6bVb92SbWXv6Vw3Ci2+tqIgfB7KL/V1yGUkje6dbrvp5Q8utAxWO6GbimkLKxMXDaw34IQlBIIUKXc7V9fVpvWfZ5lKp/mD+rTIOf4Y03XL0Tejbh/99n77ylNNUOGQjbH0IvHCixFFwK3j9rW4T7ehus62+Uf6l+Xx7VF1nVUP20/sn1QFO34mek++k+H9ProolsEMoZSGl8HS8fzU0pTdFtPlnPnSXukbOhFlwjs9fJCKYEAVcrtbv/8sh7CjaUj4oyeKEzWcE9QP6mBFgECTCm3+6fn1RBuLB0RShmFyRruCeonNdAiQIAq5Wa7+/H0MoQbS0eEUkZhsoZ7gvpJDbQIEKBK+TgYY+mIUMooTNZwT1A/qYEWAQL8jJ6hGEtHhFJGYbKGe4L6SQ20CBCgSgkAANPkggMxSBzcT0mJW86xWB2dyRruCeonNdAiQABKSYFSRmGyhnuC+kkNtAgQgFJSoJRRmKzhnqB+UgMtAgSglBQoZRQma7gnqJ/UQIsAAbdSCsdZBSF2ROHg4vfGVk5+IBY54CwotSZJ62l2xhyF6Dy+q3js1DjRFvVsVJ8u8R7jTuABcmfFio1/N4t+mp3Q1kHnwI0oME6zA2fiUspugDxXzCwdsX1tk1ZKw1nc2unRoccuM6tZPRtyFKIrJ1ifUpKKx6I7bVlWRaYU0KNLpKKUQRegvCMB3Yye7s1b3/4SGY8Lt7S1X+5iymkGxgnp4Gz8V1/PHWDGPqds6W6naOqj71U+2l0i6l1IJDVL1Qu3YRw8iqd4OwIvq4Je5CuV63A4pKOUsWLFxrebWW+M8ptT8uh+/daVe+DlVpcNLERXgFICAX7ywNtmuze4x5/z7HphfOTnPopStt+82yGn99TKKHX8ikD3tVmmEM7iqf5i4ObeDqovtnIdDgej4dq8V5nWVIH+bSlOCq5Np9QLMTRhIBePkO8m1Db7XSJd45+yLqq6KsyLmQKe3cxeTC+lNEX36bfO3A2PTIG5OscKHFAMR1M3QCmBALuf8vVtvdkR9+0mz7JstqD+Qe5jKKWmY0v3CBm+T0lnb1w5eXSTZDiLp9e5NbBh/GqDB+5TKkOiJmOh/lohjmUwqLY2TCrP69KllGpitfV+yqxdzCRLfF54drMBlNLdbz1yj69nwwWGUoLz8VLK9Wa33nyf52eJ5QdQSiqT525+WH+CoWmxNW19TqmMgo4dJp67PbA6JTOtvoatZR2zrMuiqqvi9GnZw58WTi2Lce7Ye/Q1ZlTo117aK0jAs5v1U8rTty59JYB8/VBXWOmetTt3KCWYFkwp96+r9dbo7ud5Pn+0PXW6sSslEa0Yr5/Ran36Ig2+2uJt+Ohg3SXVrcxUBAUhmA2vy6KqyuP43MhfH3+efTfs68P82JSSNnrsfUq5Y3jnfumtx6DA2KcEZ+NQyvt5ns3uVuvtav04z7PZoqdMjl4puz02xYdM4/xT65JgG41tRjxHe3Tlc5OSu3jWXVJjrqoiSNujDsPrspHbdkm1lz/NXzGbrZsW2uprIwZG81m6wurrEErJG9063fdTSh5daOuA3E2Pkg0cYfkHTB2qlLv968tqo7rPs9N84tP8gTwKcqNWSvV3Ipk2dp/zR1rGfUpFMWmOpJbYHEMvDCueFN0VWBtj2sCCNAh/HmPKIdS/+ZURm+1qs2Ay+Tt5Fu34mek++k+H9ProolsEMoZShnQzP6U0Rbf129BO7pEyWxC+TODzX1UwdahSbnf755f1EG4sHRFn9ERhsoZ7gvpJDbQIEGBKud0/Pa+GcGPpiFDKKEzWcE9QP6mBFgECVCk3292Pp5ch3Fg6IpQyCpM13BPUT2qgRYAAVcrHwRhLR4RSRmGyhnuC+kkNtAgQ4Gf0DMVYOiKUMgqTNdwT1E9qoEWAAFVKAACYJhcciEHi4H5KStxyjsXq6EzWcE9QP6mBFgECUEoKlDIKkzXcE9RPaqBFgACUkgKljMJkDfcE9ZMaaBEgAKWkQCmjMFnDPUH9pAZaBAj4KiU9GjMcsSOmfprdIeBQMa/UeFx2Gp3zCC7HaXbk/DU5uiuwoQPIXeI9xp3AA+TOihUb/24W/TQ7oa2F3HnSQYfGXTYwTrMDZ+KnlMuqCLyolmNJvH1tk1ZK07HgXiX3tbqTnbq9D9J+EDnPujvc+pSSdua64cYINnbaAncx2CniY1BK+WKQy+HbzQyne/PWt3dF43HhlrY2HzhPT8QVU8YJ6eCD4qOUy6qg1wv3YOxzyhb9bYszpyR3IZEULe+3cBuGFsdSRMXbEZh3AHeXSEUpY8WKjW83s94Y5Ten5NHdHaPLXeqWQZdbXTawEF0BSgkE+MkDb5vtXnN319nV14fbn/Lb7/RRiPsoSklmeJFWX/W7kNjXZofUmUK0o5ythKq/GLi5t6MrFfdhGAzX5r3KtKYK9Kd6rU2n1AsxNGEgF48QEaCW2O8SaRcUmqyLqq4K82KmgGc3sxfTSylN0Z0do8td6JY8ZVNeXJ1jBQ4ohqOpG6CUQIDdT/n6tt7sFHc3y64Xm923mzy/+a4/CnMfQymZjkXfp6RzNa6cPLpJMtrBXdh5VEpuDWydigQrpTokajIW6q+V+WiD4buCNkwqz+vSpZRqYrX1fsqsXcwkS3xeeHazAZTS2TG0Lid0y7h6NlxgKCU4H4dStgIJpTyYRSuaUqq+6ottH9D0OaUyClr2t+y52wOrUzLbB3/Dj1nWZVHVVXH6tOzhTwun2G2eO/YefY0ZFfq1lz7V4Vc/nSlNUv2U8iRv+ryffP1Q13fpnrXJELLAD6UEk4Ip5f51td427nGeZyr5/FF5GubGrpSWESS6UurTF2nw1RZvw0cH6y6pEliVHW2lURWjAMPrsqiq8jg+N/LXx5+XtRv2dZEZm1LSRo+9Tyl3DHuXY5N27FOCKSErZefu5/k5Mjl6pez22PiDCErZjUNtRtYcjVm3n5uU9B0meZvTI7BDPjgWw+uyEdd2SbWXf1MCWoHMKLb62oiB0XyWrrD6OoRS8ka3Tvf9lJJHF9qa5W7olkLKwjLGZQO711cOByglEKFKudu/vqw23N3P80/zB+MjTzdqpVR/J6JPpKLvUypDE82R5MXmGPo+JftRihTdFTiWUiqjs5ZDqH/zmyLWJNosmEz+Tp5FO35muo/+0yG9PrrovRaj/erH2M1YUZQaoLHNi/mujuGVO0/aI2W2IHyZwFaTVaCUQIAq5Xa3f35ZD+HG0hFxRk8UJmu4J6if1ECLAAGmlNv90/NqCDeWjgiljMJkDfcE9ZMaaBEgQJVys939eHoZwo2lI0IpozBZwz1B/aQGWgQIUKV8HIyxdEQoZRQma7gnqJ/UQIsAAX5Gz1CMpSNCKaMwWcM9Qf2kBloECFClBAC8A1mW4d/U/r3gQAwSB/dTUuKWcyxWR2eyhnvyyy+//GV5gEvHoccCASglBUoZhcka7kmWZRfXBjjVYU4JBKCUFChlFCZruCeYU6bm0GOBAJSSAqWMwmQN9wRzytQc5pRAwKmU6hFXIad1McShM/XT7BrYSWuuevFPjR8b5jqCy3Ganat4YbYoZ6N6dYn3UMrAA+TOihUb25zy93/bVO3f1jafvywPf1nWv83K32txuY85+p9/d2rr3/xuKQduQ7Yd8fd9inr5wEL01uG7HRDwUco4GmbpiO0QnbhSsnJqp0eHCgZLrUujbm9/5MenW6MrJ1ifUpKKF27LsioyVSndjZWKUoaeV/teZKY55Z9/VzRD+fLv/yb77Z8Of/mH6jd/U/355FP8/T+cHum6xX0ax6P/Q/WbU7D6t9kxQXtgkpQqM8aUbdEvG1i2C3NK4IFLKeMNKx9tTqnUTN+rfKz3XpHUnNdmmdXQUTx/W5ZVoVzk69clUlHKWLFi49yn/PPvit/8bvmXP5XqxOi3fwqcU/LonWyQBE2BtambrjE8sBD9soFFuzCnBD7wkwfeNtt95x5/bm+ozG+/a48C3UdTym7ElQrvm5p+FxK7WMghdaYQzuJ529Lc26EU8ETYsrM271WmsFWgv3p7ZlGW+vxYXRo+zc3JXSKZfsfIwaid9rtEjh5K1u2dnUH6a5xTKu40pzzppaqdIUppit7Oq2h4e16avtoCm6KfshggcEAxJLswpwR+sPspX9/Wm13nFtdZfvtts1tvvs/zbLbYaU9D3IdTynb0lEbI8H1KZfbWZmLOQZ+SUslwFs/Tlm41uFsedl1maTFcuSJRk7FQf63M+rWcLDd2P6V+b6VWLjVd9/2UWXt3F7kE0Qt5Tvnn3xXZ31R/ltSrt1IeF2CzLKPrkLIgkalYdD0bLrCnUmJOCQRcSqm4bzd5fvMdSslWLHtfD2u9UFAdw+1CrM8piXq5i+dli3z9omC50fBjlnVZVHVVnD4te/gbsm+1zDh35LooKKW8tUmi972fUphTtjIpqpeklKcfsPxtbYjONu2kwCEaPHalxJwSCDCl3L+u1luju5/n+fzR9tTpPphSOlbvAlNT0Kcv0uCrLd76C0GILdq9yHzKGWx4XRZVVRbVUpG/Pv48+9Nn5WuGWhHpKaVtTqnK5F+Wwh5bz31KSTYseZnVBfuUYEo4lPJ+nmezu9V6u1rfzbJ8/q2nTH48pTxjEdKQmvbj0+OnblfPozDd5yYld/HCbNH2+7R1zCDD67KR23ZJtZd/UyZagcwotvrafP8Qfg/lt/o6xJzyTyX9/ar1d5t+Ssmj/6nMOh9dNsx5WX4vit++gilBlXK3f31ZbVT3eXaaT3yaP5BHQe6jKaX77x17ptYpJp3MkVpy/D0lK54U3RVYE4I2cNgvek7JGHMI9W9+ZcRmu9osmEz+Tp5F0e4w6j76T4f0+uiiWwQyxpyy+7O/LMuav3eM/veUQX+bqE7IwlNmC8KXCYy/pwTnQpVyu9s/v6yHcGPpiDijJwqTNdyTDGf0JOYyzCmBHaaU2/3T82oIN5ahE0oZhcka7gnOfU3NoccCAaqUm+3ux9PLEG4sHRFKGYXJGu4J5pSpOcwpgQBVysfBGMvQCaWMwmQN9wRzytQceiwQ4Gf0DMVYOiKUMgqTNdwTzClTc5hTAgGqlACA9yHLMvyb1L8XHIhB4uB+Skrcco7F6uhM1nBPUD+pgRYBAlBKCpQyCpM13BPUT2qgRYAAlJICpYzCZA33BPWTGmgRIAClpEApozBZwz1B/aQGWgQIeCglOyatH7aO6HMm3HsivjDkqNWWCHeJ8Gp21YzjNDty/poc3RVYPRv1fMMjMfKbnI3+vNEt3YAfAGm9msa/Ywi586S9i3r5wGcfPAmmjlMptet3zxlhjB3RcMb1pbG8MO3wwg8lj5FaV7ndfZD2mjEWRm8m7cx1fjUGHzvFRl5WRaYqZW/Do+KjefLFIJfD93UwXIjGW5/7KCmS6Pa2Nh84T0/EFVO2XfR22cARLsgDU8ellGfKo4KzI6YxgvW4nzJCauRaJ+OdxFJhjGroUDazLabAy+NF0R6jTUcqShkrVmx8Xwe9kfU1BI85JY/u7hhd7lK35Clbi3rpwEJ0BSglEOAnD7xttvvWPdz+lF19VX16O1dHTHxOeURXF+cSZN87vNjXZofUmUK0o5xtcFD9xcDNvR1KAXsZrs17lWlNFeiv3p5ZlKU+nVKXhjVhIBePOC7wtN8lcvRQsi6quiocteFVPxr0di9WTC+lNEV3dowud6FbCld2Kk+5OscKHFAMR1M3QCmBALuf8vVtvdm17ttNnl9d58ch4upOfRTq5I7I9eFS9NO2Xl9UjfuUyuzt0KRurhl9Skolox3chZ1HpdTWwGz86m+4MiRqMhbqr5X5WABDUbRhUnlely6lVBOrrfdTZu1iJlni88LzdRhAKZ0dQ+tyQreMq2fDBYZSgvNxK2WW337b7Nab7/M8my0GUcp0ZPIQom0tfV8/608w1BfbXjP6nJKol3tvxrj6ahCNdkrGUwk1/JhlXRZVXRWnT8se/obsWy0zzh17j77GjAr92kuhgux4vg79lPIkb+pKAPv6oa7v0j1rkyFkgR9KCSYFU8r962q97dziKp8/Hj/fz/P2cw9n64hJyeTh8kqpT1+kmtEmuOGjg3WXVAmsyo5hGhJseF0WVVUex+dG/vr48+y7YV8XmbEpJW302PuUcsewdzk2acc+JZgSLqVc382yqy/r7Wr9OM+z2aKnTFqVstu7SgX/3+Doy3mRUmsrxF0z6lvffm5Scq+Rhq0kq4pwhuF12chtu6Tay78pE61AZhRbfW3EwGg+S1dYfR1CKXmjW6f7fkrJowttzXI3dEshZWEZ47KB3esrhwOUEohQpdztX19WG819uTpNKGYL+ijE2ZbjhKw5kfEAACAASURBVCnLRejxF5BCsXv/PaWpZshQyOYY+j4l+1GKFN0VWBtjzjBc19kuh1D/5ldGrOtos2Ay+Tt5Fu34mek++k+H9ProolsEMoZSGl8HVhSlBmhs82K+q2N45c6T9kiZLQhfJrDVZBUoJRCgSrnd7Z9f1kO4sXREnNEThcka7gnqJzXQIkCAKeV2//S8GsKNpSNCKaMwWcM9Qf2kBloECFCl3Gx3P55ehnBj6YhQyihM1nBPUD+pgRYBAlQpHwdjLB0RShmFyRruCeonNdAiQICf0TMUY+mIUMooTNZwT1A/qYEWAQJUKQEAYJpccCAGiYP7KSlxyzkWq6MzWcM9Qf2kBloECEApKVDKKEzWcE9QP6mBFgECUEoKlDIKkzXcE9RPaqBFgACUkgKljMJkDfcE9ZMaaBEg4FBKekL2GWe0ih1ROLj4vbGVUzgiSyi6v9U8NdcRXI7T7Mj5a3J0V2D9bFQPy99j3Ak8QO6sWLHp0c1inWYX1DFaLx446NC4ywbGaXbgTELmlEtylUMYlsTb1zZppTSfxU0PC/VNzWA1S82QoxBdOcH6lJJ2uLXhxgg2dtoCdzGaByyvAMOj4qN58sUgl8O3mxlO9+atb3+JjMeF+3cMxZvWGU5IB1MiQCnJ5YChjH1O2SK8rIGpaXeJqHchkbqwZCDchqHFsVSu4u0IvKwK5SJf6QaRjlSUMlas2Ph2M+uNUX5zSh49qGM0BSHXOJtTFi63umxgIboClBII8JMH3jbbvcE9/pznPz8YH/m5j6KUbIZnvajKmZpR6vgVge5rs0wh2hHRVreqvxi4ubeD3bolYTBcm4sq05oq0F+9PbMoS30apF6IoQkDuXiEfDcx6IC+XNdFL2s966Kqq0JYzPSuHw16uxcrppdSmqIHdQza+kLKpry4OscKHFAMR1M3QCmBALuf8vVtvdlx9+0mny0M/v7uYygl0bHj+Bl1n5J+f+fKyaObJKMd3IWdR6Xg1sB0/DLn5WW4MiRqMhbqr5X5WASDfmvDpPK8Ll1KqSZWW++nzNrFTLLE54VnNxtAKYM6hkG9bCmfqWfDBYZSgvPxVMq7WXa9OEMmP4ZSWkRLmmX1sFqdN9ll8kCUkl7P696bMa6+GkSjE8h2bkby8jb8mGVdFlVdFadPyx7+tHBqWYxzx96jrzGjQr/2knzww7Ob9VPK07cufS5Ivn6o67v6lx7DpgCUEkwcppT719V6S9z9PM/nj9w/yI1dKQXR6vv6Ga3Wpy/S4Kst3oaPDtZdUjZnzlTp4XkFGF6XRVWVTSp1uyMb6s+z74Z9XWTGppS00WPvU4Z0DFPrCwXDPiX4uPgo5eM8z+ffzpLJ0Stlt8d2QplPRZhTdkm0GbEchehkdDuNDo6Zn3WX1JirMqqyvExYDK/LZsBtl1R7+TdlohXIjGKrr40UGc1n6Qqrr0MoJW9063TfTyl59KCOwZMRUhaWMS4b2L2+cjhAKYEIVcrd/vVltdHcl6tstqCe4W7USqn+TiTTxm7HTzl6/z2lKUdSS2yOoe8dsh+lSNFdgfUxhuXlbbgyOms5hPo3vzNh8x1tHkQmfyfPoh0/M91H/+mQbmIX3SKQMZRS7mbWyZTVx2iJLUEpHaNxHimzBeHLBHaafDhAKYEIVcrtbv/8sh7CjaUj4oyeKEzWcE9QP6mBFgECTCm3+6fn1RBuLB0RShmFyRruCeonNdAiQIAq5Wa7+/H0MoQbS0eEUkZhsoZ7gvpJDbQIEKBK+TgYY+mIUMooTNZwT1A/qYEWAQL8jJ6hGEtHhFJGYbKGe4L6SQ20CBCgSgkAANPkggMxSBzcT0mJW86xWB2dyRruCeonNdAiQABKSYFSRmGyhnuC+kkNtAgQgFJSoJRRmKzhnqB+UgMtAgSglBQoZRQma7gnqJ/UQIsAAbdSkmO8emPriD4HTb0noeWkh4b6pdZEtZ5mJ+RojM7juxqOnRontrJmZv/T7KISeIDcWbFi49/Nop9mJ7S1kDtPOujQuMsGxml24ExcSqkd3X3WAGOVYY9zxt+TsHIuq6LPua/tYMUP6a7bGwHtNcOiK0drn1KSGo5Fd7ayZibLK8DwqPhonnwxyOXw7WaG071563MfJUV+XLil9cwHztMTccWUcUI6+KB4KCW7QqIfzo6YxggWVM5lVdCLl0NS0+4SUe9CIvXsuh3JooaOhlO8HYF1M/2+MqWilLFixca3m1lvjPKbU/Lofm/00nQ1mW1O677c6rKBhegKUEogwE8eeNts94r7fpP/dPO432y/XmXXC+1RmHN1xKTnlAr0dgt54PVdfdXvQmJfmx1SZwrRlss2OKj+YmDdTM92MhiuzUWVaU0V6K/enlmUpT6dUq/j0ISBXDxCRIA2of0ukaOHknVR1VVhXswMqx8NersXK6aXUpqiOztGl7vQLXnKpry4OscKHFAMR1M3QCmBALuf8vVtvdlp7uE2z7Isy+cPO/ooxMkdkevDpfAup+HFDkzNuE9JJ6n2mtGnpFQy2sFd2HlUBkprYGqmOS8vw5UhUZOxUH+tzMciGPRbGyb17zeO4VNNrLbeT5m1i5lkic8Lz242gFI6O4bW5YRuGVfPhgsMpQTn41LKh9s8v/222a033+f5WWIpdMR0ZPIgvjBqOTXliKGUqq/6YttrRp9TKqOgZX/Lnrs9MDfTkJe34ccs67Ko6qo4fVr28KeFU8tinDv2Hn2NGRX6tZc+/cCvfjpTWDdjOUhKeZI3fcGDfP1Q13fpnrXJELLoDqUEk4Ip5f51td627n6e5/NH/rmHs3XEpGTyYH9h9HKq47H0/TxcKfXpi1Qz2uJt+Ohg3SVVApvMZHkFGF6XRVWVTSp1u/UV6s+z74Z9XWTGppS00WPvU8odw97l2Lci7FOCKeFQytXiKstv79fb1fpxnmezRU+ZtCplt3eVCqHljDKn7MahNiN3zahvffu5SUnfYZK3OT0Cq2ayvExYDK/L5ltFu6Tay78pE61AZlQ3kyLfP4TfQ6l22Vdfh1BK3ujW6b6fUvLoQluz3A3dUkhZWMa4bGD3+srhAKUEIlQpd/vXl9VGdZ9nzYRitiCPgpxtOc5nZvaehJYz1uprm0U3NNEcyVDI5hj63iH7UYoU3RVYN5Pl5W24MjprOYT6N78yYk2izYLJ5O/kWbTjZ6b76D8d0k3solsEMoZSGrsZK4pSAzS2eTHf1TG8cudJe6TMFoQvE9hqsgqUEghQpdzu9s8v6yHcWDoizuiJwmQN9wT1kxpoESDAlHK7f3peDeHG0hGhlFGYrOGeoH5SAy0CBKhSbra7H08vQ7ixdEQoZRQma7gnqJ/UQIsAAaqUj4Mxlo4IpYzCZA33BPWTGmgRIMDP6BmKsXREKGUUJmu4J6if1ECLAAGqlAAAME0uOBCDxMH9lJS45RyL1dGZrOGeoH5SAy0CBKCUFChlFCZruCeon9RAiwABKCUFShmFyRruCeonNdAiQABKSYFSRmGyhnuC+kkNtAgQcCulx8llXogdUTi4+L2RXxh6ROhZqUmn2R3cR3A5TrMj56/J0aXAesr00HRL4cY07gQeRBcFW/14n8TW/zQ7oa2DzoEbUWCcZgfOxKWUnTKcK2aWjti+tmNQymVVxLmwl1nN6tlw+rcQXTnB+pSSdri14cYINnbaArOUSUqWdhvTuJOMUhoa3XC6N299+0tkPC7c0p48d6kT4oR0MCUcSknu6DlHzcY/p1xWBb3P9ozUDuQuEaGeLe+3cBuG+e4Pa3QhsDiJJvdFqoxp3ElGKVWW7TVi5huj/OaUPLq7Yyi5Cz5Bl1tdNrAQXWFMPRa8O/zkgbfNdt+5u+ss//lhu99sv9/kWX77XXsa4kavlM31FYOsvup3IbGvzQ6pM4VoS2qrW9XfGli6WEusC/P6RDebUaY1VaA/rZsGMuPiq40GH8t9Iz4LkyTZ0/eoY+S6KsypSPWjQW/3OtD69lJKU3RnxziYmp368JRNeXF1jhU4oBhCdBUoJRBg91O+vq03O9Utro7DQT67yvOb7+Spvxu5Uhpe4zNS09Js/3Mco8m0lSsnj66M0nxNzlZevc4tgc0pN4+ENjMZrgyJmVqbof5aofVZeeejLF9affShVEldyOik1izZtp3UD0HfJPSa4mlEUkpnx7B8WbOtekbSs+ECQynB+biVUpXMySqlOusYSClVX/XFtg9o+pxSGQUt+1v23O2BDSmLhW+x/TqsrA91WVR1VZw+LXv4d4XrMUzafNSJJhESeS2SJOvXV4SOoTZ6P6U8fevSl0DY94Flu75L59sumZQrgJsOpQRjhynl/nW13prc4zzPZgvjIy83ZqUUBtEeqbUYrdYnK1JO2uJt+Ohg3SXVArOUxTQ7zIbXZVFV5XF8buSvj7+tQOcqpaUTvqNS0kaPvU8pN6KnTJoLhn1K8HFxKOX9PM9md6v1drW4yrKrL31lcuRK2THQnLIbpdvNvG5Xzx1d+dykpG98ytucYmCW8umzoxrsi9hZO18kv90N8W+LEXf11bbxq/7fvvp6vlLyRrdO9/2UkkcX2prnLnRCnrKwjHHZwO71lcMBSglEqFLu9q8vq43qPs9OE6nZlw15FOSglAzjPqWimHQWS2qJzTH03UT2ExQpuhSYpezTXMKfx5iKE+rf/Eed7bf6RCb+gk+m/6KnM7UNqv6YSK8GkmwMpTQ1Os+YFEzwMZbblqAhd2N5QlJmC8KXCWw1WQVKCQSoUm53++eX9RBuLB0RZ/RE4b0N7/dd63Lf0CbbMZIFLQIEmFJu90/PqyHcWDoilDIK72K4Oufxn+r3ixWZyXaMZEGLAAGqlJvt7sfTyxBuLB0RShmFyRruCeonNdAiQIAq5eNgjKUjQimjMFnDPUH9pAZaBAjwM3qGYiwdEUoZhcka7gnqJzXQIkCAKiUAAEyTCw7EIHFwPyUlbjnHYnV0Jmu4J6if1ECLAAEoJQVKGYXJGu4J6ic10CJAAEpJgVJGYbKGe4L6SQ20CBCAUlKglFGYrOGeoH5SAy0CBDyVUj75zAtb4v1SGw5nOYOKKb5+0ml2B3fNOE6z44e4CdGlwHrK9LR4S+HeY9wJPVrwnFix8X8dop9mJ7R1UCcMOjTusoFxmh04E6dStq8VPxw7bMgxdkThUOpLYX5hunOlww5As7x+rFZZ+mLNsOjKUdanlLQz1w03RrCx0xaYpUxSslRGKkopXwNyOXxfB8Prxluf+ygp8uPCbe3JO3myh54HBcYJ6eBswueUflfYcJwdMY0RzHE/5UFSB9/UGrS7RIT0LTVjvAzEEMfSTIq3ENggj+rDi447H3FO2bJsb480v25+c0oe3d0xusyll50/Sjaw35AFpQQC/OSBt812z9zXq+x6sd1vtvuH25/y2+8b9tnpXB1xLHNK64V9Aal1iXKpM18RKEudKUQ7ItoGB9XfGlhqldC7MrTZqTKtqQL92yyXVVGUpT6dUg911YTBen+I0RD7zSHdZOuUdVHVVWFezBTwfB3sxfRSSlN0Z8cwTWhZJfFHpsBcnWMFDiiGo6kboJRAgN1P+fq23uyYu5tl14vNbr3ZfbvJ85vva/bZ6eSOGKY/Q+LaQCrKMmBOEr5PSdO314w+JaWS0Q7utsLqA6UlsDnl5pHwzcaykt8MiZqMhfprZT6WwaDo2jCpPK9Ll1KqidXW2yizdjGTLPF54fk6DKCUjo5xfNgae55SJhEYSgnOJwmlTEcmDx4vjLgeGZSa9ScY6ottz0yfUyqjoGV/y567PbAhZbHwLUbDj3Hqsqjqqjh9Wvbw7wqn1VQz2+Nzx96jrzEjNTr/4Ifn69BPKU/fusraEJ21dRuYFEGc0UIpwbRgSrl/Xa23zN3Nsqsvx8+Lq2x2d/T/MstmCx7Y7GwdMSmZPHgvi8VIzSg2+vRFqhlt8TZ8dLDukmqBWcpimh22Reyiqsrj+NzIXx9/a4GUrxlqRYxHKWmjx96n9GzErjrT3HoMCox9SnA24Ur57TbPb+/X29X6cZ7n82/nKWW3d5UKjh8lBhbY/xc9NH13Rupb335uUtI3PuVtTjEwS/n02SELFsPrsln1a5dUe/k3paAVyIxiq6+NFAm/h/JbfR1CKXmjW6f7fkrJo9vb2lCdwsoEf5RsYPf6yuEApQQiVCl3+9eX1Ya5xSy7+tz89/OsWd2aLUyBzc62HKeSwtwykb+nNNUMGQrZHEMvH/tRihRdCswtd6y8CoYro7GWSKh/XR7XFlnXUf20/cj2QVG042em++g/HdKN7qJbBDKGUhpfB1YUpQZobPNivqtjGAK3pvgE9ulyFw0sWdECpQQCVCm3u/3zy3oIN5aOiDN6ojBZwz1B/aQGWgQIMKXc7p+eV0O4sXREKGUUJmu4J6if1ECLAAGqlJvt7sfTyxBuLB0RShmFyRruCeonNdAiQIAq5eNgjKUjQimjMFnDPUH9pAZaBAjwM3qGYiwdEUoZhcka7gnqJzXQIkCAKiUAAEyTCw7EIHFwPyUlbjnHYnV0Jmu4J6if1ECLAAEoJQVKGYXJGu4J6ic10CJAAEpJgVJGYbKGe4L6SQ20CBCAUlKglFGYrOGeoH5SAy0CBMJvcrb6OBA7YnBqw+FfzrOPyJJOs/NI33GaHTl/TY4uBObnuGlHrlkK9x7jTuABcmfFio2tfrxPYut/mp3Q1v2Ovks/ME6zA2fiVMr2tWq7GPfxwtIRe6Y2HJ7lNBwnfUZqyrnVdXufrT19Xmnd0dqnlLQz1/nVGHzstASW0jkcltY7KlNRSvlikMthrB+/M8pDXknjceFCW+uBpU6IE9LBlMCcktKjnML755kauQuJ5GFJX7gNQ4tjqVzFWwgspkPui1RJRSljxYqNs35c9175vZI8utCg4u1UtNqCLre6bGDRrhYoJRDgJw+8bbZ75r5eZdcLh4/DfVyl7DGnZKnpdyHZpnW26KYQ7chmq1vVXwhsfyRKjsFwbd6rTGuqQP82y2VVFGWpT6fU6zg0YSAXj5DvJtQQ+10iRw8l66Kqq9OHAP11jcv0di9WTC+lNEW3NqhYJYYrukhgU3SuzrECBxTD0dQNUEogwO6nfH1bb3bM3c2y64XDx+E+qlJyZeuXWjM2F2VJxwJL+vqUlEpGO7jbCqfbIgS2PLKvvB4OZsOVIVGTsVB/rWDHMhi+K2jDpPK8Ll1KqSZWW++nzNrFTLLE54U8LhtTjaSUUoMKgmRdqY2kZ8MFhlKC84FSUoLKKctkaGqtr/pi29PX55TKKGjZ37LnHrQPJBa+xWj4MU5dFlVdFadPyx7+rGyKuhnnjr1HX2NGhX7tJfngh9Ax1Ebvp5Snb11lbYjOGlQKzMrjUyW8MqCUYOwwpdy/rtZb5u5m2dUXh4/DfTyldMpkUGpqqt30RUpfW7wNHx2su6TySCSm2WE2vC6LqiqP43Mjf338rQVSvmaoFTEepaSNHnufUmpEU17WToh9SjAloJSUgJ1FjzL7/6Kn24k7fnKnr1aaNrKdRgcyy5RtsQU2P3LLgsXwumxW/dol1V7+TSloBTKj2OprM/QbzWfpCquvQyglb/SAOb3pJeLRhbY2BrZ1Qh44aGXiPQO711cOByglEKFKudu/vqw2zC1m2dVnh4/DfTClVH85ImwG9v57SlP6pJbYHIP94YnuI0UXArNHXs0l/HmMqTih/nV5XC5kDaD6afuR7YOiaMfPTPfRfzpk+UWPTSBjKKWxUxnqn1WHxcdoiS1BwyO5k3ukLPWidwwsmdwCpQQCVCm3u/3zy3oIN5aOiDN6ojBZwz1B/aQGWgQIMKXc7p+eV0O4sXREKGUUJmu4J6if1ECLAAGqlJvt7sfTyxBuLB0RShmFyRruCeonNdAiQIAq5eNgjKUjQimjMFnDPUH9pAZaBAjwM3qGYiwdEUoZhcka7gnqJzXQIkCAKiUAAEyTCw7EIHFwPyUlbjnHYnV0Jmu4J6if1ECLAAEoJQVKGYXJGu4J6ic10CJAAEpJgVJGYbKGe4L6SQ20CBCAUlKglFGYrOGeoH5SAy0CBPrc5OxzNBTHlni/1IbDUk71YK+AU8vE1086ze7grhnHaXbk/DU5uhCYn+OmHXFmKdz4xp3A4+jOxP91iH6aXVDH4N0yvKiXD4zT7MCZOJWyfa3YWd7Wo7fNGDti79SGw66UfUpnSY3WqnJudd3eZ2uvGRZdOcr6lJJ25jq/GoOPnZbAUjqHw9J6R+X4xp0ElNLQ6IbTvXnrcx8lRX5cuH/HYN3SkTJOSAcflD5zypagscXZEd93pLJiLmffwnnOKcldSKSuLZkLt2FocSwir3gLgcV0yH2RKuMbdxJQSpVle42Y0sj6GoLHnJJHD+kYUrcMutzqsoGF6Arj67HgHeEnD7xttnvmvl5l1wvq+f0mz67ueGCzc3XEtOeUyppj0HDqu/qq34Vkm9bZoptCtKOcbXBQ/YXA9keitBgM1+a9yrSmCvQ3Z6ktsHVZaZNsZcJEREC7sbIuM/0eEjW8IZ2yLI4do64K3x7i+ToYi9CY5VZKU/SQjmHvllL9abd2EXWOFTigGEJ0FSglEGD3U76+rTc75u5m2fVC9/x2k2f57TdDYLOTOyLXh0thLmftvO4xJLUuUb4hVJQlHQssNaN/9z8N13xNTpAWxQ4hsOWRfeX1cDAbrgyJmToohvpz1Eapy5NmqSrbBbBKUDeJU27wokOsKZ2sXdUka30Snq/DAEoZ1jGEbhlXz4YLDKUE59NTKUNlUlbKdGTyEHuV2F8pVV/1xbbXjD6nJELu3psxrr567AOJhW8xGn6MU5dFVVfF6dOyhz/FZKK28uY5oPKvGv7DMP8g4vk69FPKk7yVtVnr9QZtA9tTPvmmI35BgaGU4HyYUu5fV+stc3ez7OpL89/7eZ7lt/eGYJKzdcSkZPJweaXUZy1STtoqWfjoYN2OkkciMc0O29S8qKryOD438tfHn2AsTV1mZX2qGF+l1GafF1FK2uix9ymDOgYpV0Jbj0GBsU8JziZcKRdXmaKa5yqluqGUBq4fJQpbZb6pNZg2GtsKcdeM+ta3n5uU3MvF1u0oOhIZHrnVQPhjm3a+SH67G+JPYKuvbQxWeKWC9Biq1NH9UW2307yKG0UpeaMHzOlNKsCjh3QMQ7cUUg5amXjPwO71lcMBSglEqFLu9q8vqw1zi1l29Xm1eVltPs8ylU/zB1N4g7Mtx6mkMLd0/qFbUCF7/z2lqWbIUMjmGOwX/rqPFF0IzB45V14Fw/WvHF0iof7qb3xohanF7BqrXVxVFjabyi3IfHFZFRn5GdAxDE8nqlIaXweDYaw6LD7merEkaE6HdauglKVe9I6BnSYfDlBKIEKVcrvbP7+sh3Bj6Yg4oycKCRjuoeeXI4H6ARpoESDAlHK7f3peDeHG0hGhlFG4sOHqymuSTLZjJAtaBAhQpdxsdz+eXoZwY+mIUMooTNZwT1A/qYEWAQJUKR8HYywdEUoZhcka7gnqJzXQIkCAn9EzFGPpiFDKKEzWcE9QP6mBFgECVCkBAGCaXHAgBomD+ykpccs5FqujM1nDPUH9pAZaBAhAKSlQyihM1nBPUD+pgRYBAlBKCpQyCpM13BPUT2qgRYAAlJICpYzCZA33BPWTGmgRINDnJmfhgCsBW+L9UhsO8YXRj8TUMBffM7WDqR6CTh3j8dnxbVJ0ITA/vu1swyMRdFb9mbFi43wdXCex9T/NTmhrIfdep9mlEhin2YEzcSolu4uoO0wz7LQwc0fsm9pwWF4YfieT/tBSdt/UWD3oV1rw06lJYboTrNlR3vxIdxZdCCyl08PwqPhoHg+TsFIaGt1wujdvfXvnNB4XbmlQQ+7C64kT0sGU6DOnbAgbclwdMY0BrOeNkv1eP22Gqt6FRPJw345kVMPGx/IdRPEWAovp9DU8Eh9xTtmybG+PVBpZX0PwmFPy6O6O0eUudUuesrWolw4sRFeAUgIBfvLA22a7Z+7rVXa9IJ6PP+fc0+4cHdF2BdC7E6yU4sjrm5p+F5JtWmeLbgrRFss2OKj+QmD7o1DDtXmvMq2pAv3bLJdVUZSlPp1Sr+PQhEFdNTbeNMnKqqXbRS9rPeuiqqvCvJgp4PHFMSul6yS9lNIU3dkxutyFbslTNuXF1TlW4IBiOJq6AUoJBNj9lK9v682OubtZdr1QfL7d5FmWzRY8pNUJHfE4CiWhk+FKaV+ADEutGZuLsqRjgWUM1qekVDLawd02Mui2CIEtj8INV4ZETcZC/bWCHctg+K6gDZPK87p0KaWaWBtaz6htFfVDiFTK47Ix1UhK6ewYWpcTumVcPRsuMJQSnE9PpVxvduvN93keIJaeX6IvTqBSOrZXe63lZuqLbR/Q9DmlMgpa9rfsuQftA4mFbzEafoxTl0VVV8Xp07KHPyub0n2Mc8feo68xo0K/9pl88MPxxbFJqp9SnuStrA3RWYO2gXnuJPV0xC8oMJQSnA9Tyv3rar1l7m6WXX1h/vfzPJ8/msIbnO/GzKUJ0jZnmcOVUp++SKlri7fho4N1l1QeicQ0O2w/4CqqqjyOz4389fG3FkgZz9WKGI9S0kaPvU8pN6K9y7EvstinBFMiWCnv53k2u1utt6v14zzPZgsvmbQppfL+jXFO6R4dA/7mpN2JO37qdvV8CtN+blLSd5jkbU4psPlRb8Prsln1a5dUe/k3paAVyIxiq6+NGBjNZ+kKq69DKCVv9IA5vbyJ3nyS25p9EaTdUkg5aGXiPQO711cOByglEKFKudu/vqw2zC1m2dXn5r+fZ6fFrU/zB1Ngs3P+AVkKE8pDkFI6FiDDUmvroRuaFJpBTs2PFYb94YnuI0UXArNH5xiujM5aIqH+dXlcW9Qr6KAvvmr7ke2DomjHz0z30X86pBvdRbcIZAylNDW6qf5ZdVh8jJbYEnTkzpP2YkZ33gAABbVJREFUSFnqRe8Y2GqyCpQSCFCl3O72zy/rIdxYOiLO6InCZA33BPWTGmgRIMCUcrt/el4N4cbSEaGUUZis4Z6gflIDLQIEqFJutrsfTy9DuLF0RChlFCZruCeon9RAiwABqpSPgzGWjgiljMJkDfcE9ZMaaBEgwM/oGYqxdEQoZRQma7gnqJ/UQIsAAaqUAAAwTS44EIPEwf2UlLjlHIvV0Zms4Z6gflIDLQIEoJQUKGUUJmu4J6if1ECLAAEoJQVKGYXJGu4J6ic10CJAAEpJgVJGYbKGe4L6SQ20CBDof5MzPSzThdwRQ1MbDls5zYe6nXVElnSanTlHe3Qen5y/JkcXAvNz3LRDzyyFe49xp9+Z+mmcxO/fzaKfZie0tZB7r9PsUgmM0+zAmTiVsn2t+OHU8ZQyPLXhMJbTdJJ7d2i0IPMWq1mtdknU7X229rPjeaOwwmiHWxtujGBjpyWwlM7hsLTeUZmKUsoXg1wO325mON2bt77lJT2Yotsb1HzgPD0RV0wZJ6SDD0q/OeWyKujNrk7sifdJbTicL8yS3e/UNzXtLhH1LiQy4Fneb+E2DC2O5TxzxVsILKZD7otUSUUpY8WKTUA3UxpZPJ7f1M48urtjdLlL3TLocqvLBhaiK0ApgQA/eeBts90z9/Uqu160/727zq6+Ptz+lN9+NwU2O2tHbK6FSGD4OhzcL0x37ZLzPg1Xakapa26FYjkK0U0h2hq1DQ6qvxDY/khsM4Ph2rxXmdZUgf5tlqevWNp0Sr0QQxMGcvEIEQFqiP0ukaOHknVR1VVhXswU8O9mlmJ6KaUpurNjdLkL3ZKnbMqLq3OswAHFcDR1A5QSCLD7KV/f1psdc3ez7Hqhf/52k+c3302Bzc7SEQ2vx2WRX5h2wDCN0qGpGfcp6fSaKyePbi7MUh7A9YFSCGx5ZF95PRzMhitDoiZjof5awY5lMHxX0IZJ5XldupRSTay23k/Z9oOuQ5x765ZWApZqJKV0dgytywndMq6eDRcYSgnOJ1gpW4GMopTqN/70lVIdQZTP0vTSXylVX/XFtg9o+pySFMa9N2NcfWWBrY+EGcnhYL9/sawPdVlUdVWcPi17+LOyKY1gnDv2Hn2NGRX6tZe9erB/N+uhlCd505dqyNcPdX2X7lmbDCEL/FBKMCmYUu5fV+stc3ez7OrLertaP87zTCWfP5rCG5z4c6FuZHtP443YXhg6giijdt/Xzyg2+vRFqhFt8TZ8dLDuksojkZhmh9nwuiyqqjyOz4389fG3FkgZz9WKGI9S8m4Wd59SbkR7l2NfB7FPCaZEqFJ27n6e+8ukRSk7Up9Tdntsqpd15c+RGk1BSaLNyJCjNbqhMPoOk7zNKQU2P3I3l32xPWvni+S3uyH+TSloBTKjupkU+f4h/B5KtdS++jqEUvJGD5jTm1SAR5fbWvcwdEsh5aCVifcM7F5fORyglECEKuVu//qy2jC3mGVXn3XP+3n+af5gCmx2o1ZK9Xci3dy39Y25T6kMTTRHMhSyOYZeGPajFCm6EJg9cq68CoYro7OWSKh/8zMwthyhLVOQyd/Js2jHz0z30X86pBvdRbcIZAylNHYzQ/2z6rD4GC2xJejInSftkbLUi94xsNVkFSglEKBKud3tn1/WQ7ixdESc0ROFyRruCeonNdAiQIAp5Xb/9Lwawo2lI0IpozBZwz1B/aQGWgQIUKXcbHc/nl6GcGPpiFDKKEzWcE9QP6mBFgECVCkfB2MsHRFKGYXJGu4J6ic10CJAgJ/RMxRj6YhQyihM1nBPUD+pgRYBAlQpAQBgmlxwIAaJg/spKXHLORarozNZwz1B/aQGWgQIQCkpUMooTNZwT1A/qYEWAQJQSgqUMgqTNdwT1E9qoEWAAJSSAqWMwmQN9wT1kxpoESCgKSUcHBwcHBwccZmgogAAAACAUgIAAAAS/x8vPsFtceQY9gAAAABJRU5ErkJggg==" />
提示。先按userIP分组,再按时间排序,最后编号。
代码如下:
- select row_number() over (partition by UserIp order by insertTime),* from useraccess
以上就是SQL Server数据库row_number() over() 来自动产生行号的过程,本文我们就介绍到这里了,希望本次的介绍能够对您有所收获!