Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- fk_nota_fiscal | fk_produto | valor | campo2 | campoXXX
- 244060 | 0010101 | 100,00| X | A
- 244060 | 0010101 | 100,00| X | B
- 244060 | 0010101 | 100,00| X | C
- ROW_NUMBER() OVER(PARTITION BY fk_nota_fiscal,fk_produto ORDER BY fk_nota_fiscal,fk_produto) AS ROWID
- SELECT * FROM FROM CTE_vwItensRefaturar WHERE ROWID = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement