/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

1 vote292 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote266 views1 answer
Postgres jsonb array push new element
SQL
1 vote287 views1 answer
How to use db.execute
SQL
0 vote268 views1 answer
Oracle allow space to user
SQL
1 vote296 views3 answers
Sql union
SQL
5 votes271 views3 answers
Select tables from mysql database
SQL
5 votes285 views5 answers
Find max number in sql
SQL
0 vote279 views3 answers
Insert query in ci
SQL
0 vote313 views1 answer
Traccar mysql
SQL
0 vote273 views1 answer
Hibernate xml property MySQL url, username and password
SQL

Share