greatest-n-per-group Archives

Programming, sql

IT Nursery

This question already has answers here: Fetch the row which has the Max value for a column (35 answers) Closed 4 years ago. ...

Programming, Python

IT Nursery

Suppose I have pandas DataFrame like this: df = pd.DataFrame({'id':[1,1,1,2,2,2,2,3,4],'value':...

I want to return top 10 records from each section in one query. Can anyone help with how to do it? Section is ...

How do you get the rows that contain the max value for each grouped set? I’ve seen some overly-complicated variations on this question, ...

Is there a nice way in MySQL to replicate the SQL Server function ROW_NUMBER()? For example: SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY ...

I have a table that is a collection entries as to when a user was logged on. username, date, value -------------------------- brad, 1/2/2010, ...

Suppose I have a table of customers and a table of purchases. Each purchase belongs to one customer. I want to get a ...

Table: UserId, Value, Date. I want to get the UserId, Value for the max(Date) for each UserId. That is, the Value for each ...

I have a table which I want to get the latest entry for each group. Here’s the table: DocumentStatusLogs Table |ID| DocumentID | ...