python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - partition

Function that returns MAX OR MIN dates based on ID count

I have a task in SQL Server where I need to return the RESULT_DATE column using ID, PRODUCT_ID and DATE columns. Task criteria: If DATE column is filled once for each PRODUCT_ID then I need to return...
test-img

Konstantins Kovalovs

sql

sql-server

tsql

partition

dense-rank

Votes: 0

Answers: 1

Latest Answer

You can use a CTE, Select all rows with a non-NULL Date giving each a row_number, then use a second CTE to fetch all rows from the first CTE equivalent to the date with the largest row number per prod...
test-img

Steve Ford

Running Total OVER clause, but Select Distinct instead of sum?

I have the following data set: | EMAIL | SIGNUP_DATE | | A@ABC.COM | 1/1/2021 | | B@ABC.COM | 1/2/2021 | | C@ABC.COM | 1/3/2021 | In order to find the running total ...
test-img

Samantha Valley

sql

distinct

window-functions

partition

Votes: 0

Answers: 3

Latest Answer

One way would be to cross-join the results and filter the joined table having a total <= to the running total: with counts as ( select *, Count(*) over (order by SIGNUP_DATE asc) as tot ...
test-img

Stu

Split dataframe by column and keep a set of common columns in each subset

I have a dataframe that has too many variables for me to work with in Stata, so I'm trying to partition it vertically in R so I can work with the smaller sets in Stata. However, I need to keep 5-10 id...
test-img

Kelly

r

dataframe

split

stata

partition

Votes: 0

Answers: 2

Latest Answer

You can use split(). Quick example how to divide df into 4 parts: x <- split(your_data_frame, rep(1:4, length.out = nrow(your_data_frame), each = ceiling(nrow(your_data_frame)/4))) After that you ...
test-img

Bart

Partitioning line items in SQL Server

There are three values for column named custom_value, Viable, Non-Viable or none. I want to partition the Viable values because it can have multiple Viables. (To understand this Viable choice is just ...
test-img

Steven Marsh

sql-server

partition

Votes: 0

Answers: 2

Latest Answer

SQL Server partition supports a single column only as a Partition Key. If you want to support multiple columns in a Partition Key then you have to define the computed column first then apply the parti...
test-img

JERRY

Posts

Questions

Blogs

Jobs