Advertisement
Guest User

Untitled

a guest
Aug 30th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. fk_nota_fiscal | fk_produto | valor | campo2 | campoXXX
  2. 244060 | 0010101 | 100,00| X | A
  3. 244060 | 0010101 | 100,00| X | B
  4. 244060 | 0010101 | 100,00| X | C
  5.  
  6. ROW_NUMBER() OVER(PARTITION BY fk_nota_fiscal,fk_produto ORDER BY fk_nota_fiscal,fk_produto) AS ROWID
  7.  
  8. SELECT * FROM FROM CTE_vwItensRefaturar WHERE ROWID = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement