/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 vote151 views1 answer
Sqlite unique multiple columns
SQL
0 vote117 views1 answer
Trim sql oracle
SQL
1 vote123 views1 answer
Moodle query item quiz
SQL
0 vote135 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
-1 vote138 views1 answer
Mysql select count if contains
SQL
3 votes123 views2 answers
Oracle apex charging debug
SQL
0 vote150 views1 answer
Sql last time database was accessed
SQL
2 votes128 views1 answer
Mysql select random id from table
SQL
1 vote133 views2 answers
Extract weekday from date in sql
SQL
0 vote133 views1 answer
Sql select rows with different values in one column
SQL

Share