sql - Query to change the values of the column? -

sql - Query to change the values of the column? -

i have table contains column number order

class="lang-none prettyprint-override">functionid name parentfunctionid orderno enabled controllername actionname 1 nikhil 0 10 1 nik 2 sahil 0 20 1 sah 3 2 10 1 sah withsnew 4 user 2 20 1 sah users 5 pen 2 10 0 sah pend 44 user summary 2 210 1 sah usersummary 45 summary 2 230 1 sah summary 46 hourly 1 231 1 nik hourly 47 code 1 232 1 nik code

i want table

class="lang-none prettyprint-override">functionid name parentfunctionid orderno enabled controllername actionname 1 nikhil 0 1 1 nik 2 sahil 0 2 1 sah 3 2 1 1 sah withsnew 4 user 2 2 1 sah users 5 pen 2 3 0 sah pend 44 user summary 2 4 1 sah usersummary 45 summary 2 5 1 sah summary 46 hourly 1 1 1 nik hourly 47 code 1 2 1 nik code

use rownum feature:

select functionid , name , parentfunctionid, rownum order_no, enabled, controllername , actionname table name;

if want rownumbers reset based on particular conditions, utilize partition along row_number as:

select functionid , name , parentfunctionid, row_number() on (partition parentfunctionid order functionid ) order_no, enabled, controllername , actionname table name;

sql sql-server sql-server-2008