Shulou(Shulou.com)06/01 Report--

Select row_number () over (order by name) as rowid, sysobjects. [name] from sysobjects

Is an analysis function that generates a permutation select row_number (XX) over (partition by order by XX [desc/asc]) from table Partition by is used for grouping, and you can use this to sort within a group. Order by is used to determine the benchmark for sorting. Sort the use of row_number in SQL Server by that column-No hate Star Morning-use of sql over (partition by) windowing function in blog Park-attack Blackie-brief description of windowing function in blog Park http://www.cnblogs.com/huangchuxian/p/7808051.html sql-CSDN blog https://blog.csdn.net/qweqweqwe159/article/details/70739003

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.