/SQL/Create row number in sql

Create row number in sql

Create row number in sql

SELECT t.A, t.B, t.C, ROW_NUMBER() OVER (ORDER BY t.A) as newId
  FROM dbo.tableZ AS t
  ORDER BY t.A;

0

Source: stackoverflow.com

Tsql row number

SELECT 
   ROW_NUMBER() OVER (
 ORDER BY first_name
   ) row_num,
   first_name, 
   last_name, 
   city
FROM 
   sales.customers;

0

Source: sqlservertutorial.net

Similar codes

0 vote197 views1 answer
Oracle query to see what scema i am working in
SQL
2 votes201 views1 answer
Columns Present in a table
SQL
5 votes420 views2 answers
How to ascending order in sql
SQL
22 votes216 views3 answers
Remove all records from table mysql
SQL
-1 vote243 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote207 views1 answer
Oracle session statistics
SQL
1 vote295 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote164 views1 answer
How to set field to null in sql
SQL
11 votes195 views2 answers
Mysql set safe mode off
SQL
4 votes196 views1 answer
Mysql insert from local csv
SQL

Share