window-functions Questions

Postgresql – sql [postgres] window function how to create column with last project date?

September 2, 2022
Dmitriy_kzn
2 Answers

i'm knew with window function I have two tables which i join together (One user could have many project). Each Project has their own date (date_project) I need query all users with thier projects and add a column in the…

VIEW QUESTION

Postgresql – Get certain rows, plus rows before and after

August 23, 2022
dbeavernoob
2 Answers

Let's say I have the following data set: ID Identifier Admission_Date Release_Date 234 2 5/1/22 5/5/22 234 1 4/25/22 4/30/22 234 2 4/20/22 4/24/22 234 2 4/15/22 4/18/22 789 1 7/15/22 7/19/22 789 2 7/8/22 7/14/22 789 2 7/1/22 7/5/22…

VIEW QUESTION

Previous
Page 1
…
Page 7
Page 8
Page 9
Page 10