in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • Row_number() Function with no specific order

    Row_number() function is used to generate row number to rows based on the column which is ordered What if you want to generate row number without ordering any column Here is the method (Consider Suppliers table from northwind database) 1 Assign dummy column with literal 0 and order it by that column...
    Posted to Madhivanan (Weblog) by Madhivanan on Sat, Nov 29 2008
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems