python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - partition-by

how to write a rank() partition by query on access?

I need to write a rank query, but i have to do it on access. How do I translate the following query? PERIODO, SUM(IMP_ENTRATE_ATT) AS TOT_ENTRATE, RANK89 OVER(PARTITION BY PERIODO ORDER B...
test-img

Michaelle Sameer Ta Ani

sql

ms-access

rank

partition-by

Votes: 0

Answers: 1

Latest Answer

Access SQL has no ranking functions. You can use my function RowRank from GitHub: VBA.RowNumbers: ' Returns, by the value of a field, the rank of one or more records of a table or query. ' Supports al...
test-img

Gustav

Microsoft SQL Server 2016 - T-SQL puzzle - overlapping date ranges in segregated rows - 'Gaps & Islands' problem

I have asked 'Gaps and Islands' questions in the past, but this one is significantly different. I have an interesting question in Microsoft SQL Server 2016 database, T-SQL language. (Refer to image f...
test-img

user3812887

date

tsql

sql-server-2016

gaps-and-islands

partition-by

Votes: 0

Answers: 1

Latest Answer

You can use the following query: ;WITH Dates AS ( SELECT EmployeeId, EmployeeName, SomeDate, ROW_NUMBER() OVER (PARTITION BY x.EmployeeId ORDER BY x.SomeDate) AS RowNum FROM ( ...
test-img

Razvan Socol

Using OVER PARTITION BY in higher levels

I've been struggling with this problem. I have a table that looks like this: Date Location SkU Model Type Qty 2020-01-01 01A AB1 One A 10 2020-01-01 01A AB1 One B 3 2020-01-01 01A AB2 One ...
test-img

Christian Villanueva

sql-server

window-functions

partition-by

Votes: 0

Answers: 1

Latest Answer

This seems to do the trick. You may want to test with a larger data set. I pulled out the 'higher level' of data into a CTE, apply the lag and then join this back to the original set of data. What I ...
test-img

Brett

SQL query over partition with condition

I have a table like this, in SQL Server 2019: ITEM_ID Parent_Item Talle Existencia 909296 280647 4 1 909296 280647 4 1 909296 280647 4 1 909297 280647 5 1 909297 280647 5 1 909297 28...
test-img

Maximiliano Vazquez

sql

window-functions

partition-by

Votes: 0

Answers: 1

Latest Answer

One way is using a derived query to count the number of unique values per Parent_Item SELECT yt.Item_Id , yt.Parent_Item , yt.Talle , yt.Existencia , cnt.NumOfTalle AS [Rea...
test-img

SOS

Posts

Questions

Blogs

Jobs