/SQL/Avoid duplicate in one to many relationship join in sql

Avoid duplicate in one to many relationship join in sql

SELECT columnlist, 
rn = ROW_NUMBER() OVER (PARTITION BY sales.salesID ORDER BY payment.paymentID)
FROM sales JOIN payments ON sales.salesID=payments.salesID

Source: stackoverflow.com

Similar codes

0 vote315 views1 answer
How to find sql server installation folder
SQL
0 vote308 views1 answer
Postgresql port 5432 not open
SQL
1 vote242 views1 answer
Ms sql how to see active job current run time
SQL
10 votes310 views4 answers
Else if mysql
SQL
1 vote307 views1 answer
Update from select oracle
SQL
7 votes296 views3 answers
Sql fill table with info from anothe rtable
SQL
8 votes286 views1 answer
Show mysql user table
SQL
2 votes286 views1 answer
Date conversion in mysql column
SQL
0 vote280 views1 answer
How to create an SQL save method in ruby
SQL
17 votes289 views2 answers
Mysql date to string
SQL