如何使用重复的行进行多列分区？ [英] How to I do multiple columns partitioning with the rows being duplicated?

问题描述

嗨成员，



我有一套SQL存储过程来使用分区来获得百分位数。通过执行以下分区，我能够正确获取百分位数据。但是我的问题是每行都有重复。例如，对于每个DESC，当假设仅为1行时，存在多个重复。为什么会这样？

 row_nums  AS  
（ 
  SELECT   DATE ， DESC  ，NUM，ROW_NUMBER（） OVER （ PARTITION   BY   DATE ， DESC   ORDER   BY  NUM  ASC ） AS  Row_Num 
  FROM  ****** 
）
  SELECT  ..... ............ 

解决方案

在该表上存在导致重复的错误或者您需要使用DISTINCT。

Hi members,

I have a set of SQL Stored procedure to use partitioning for my ranking to get percentile. by doing the below partitioning I am able to get my percentiles data right. However my problem is there are duplicates in each row. E.g for each DESC there are multiple duplicates when it is suppose to be only 1 row. Why is this so?

row_nums AS 
	(
		SELECT DATE, DESC, NUM, ROW_NUMBER() OVER (PARTITION BY DATE, DESC ORDER BY NUM ASC) AS Row_Num
		FROM ******
	)
SELECT ................. 

解决方案

There is a bug causing duplicates on that table or you need to use DISTINCT.

这篇关于如何使用重复的行进行多列分区？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！