/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

2 votes393 views1 answer
Mysql select true or false
SQL
0 vote331 views1 answer
Mysql select all where count more than"
SQL
1 vote305 views1 answer
Oracle boolean to varchar
SQL
0 vote345 views1 answer
Oracle list subpartitions
SQL
4 votes347 views2 answers
Postgre sql create table
SQL
0 vote315 views1 answer
Store query result in variable sql
SQL
1 vote371 views2 answers
Sql server backup table
SQL
2 votes342 views1 answer
Change primary key sql
SQL
7 votes332 views3 answers
Postgre describe table
SQL
5 votes334 views2 answers
Sql create tabel with primary key auto_increment code
SQL

Share