Pandaaaa906

Untitled

Mar 10th, 2021
98
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select *
  2. from(
  3. SELECT
  4. row_number() over(partition by [proDefine6], [brand], [cinvCode] order by [cinvCode]) r,
  5. count(*) over(partition by [proDefine6], [brand], [cinvCode]) c,
  6. *
  7. FROM [dbo].[product]
  8. ) tmp
  9. where tmp.c>1
RAW Paste Data