Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in greatest-n-per-group

Need help with a complex Join statement in SQL

sql greatest-n-per-group

MYSQL How do I Select all emails from a table but limit number of emails with the same domain

What SQL query returns the row with the most recent Date and Time (Column B and C) for each unique Column A?

Retrieving data from PostgreSQL DB in a more efficient way

Comparing two values in Postgres in one query

MySQL - How to get latest row value grouped by a certain field?

MYSQL Join - Parent and Child table join and get only the latest record from the child table

Group BY serial number and select latest (last) created date for that record

Select rows with Max(Column Value) for each unique combination of two other columns

Get most recent row with group by and Laravel

Performing `top_n`-like operations on tibbles with intersecting groups

Select top three values in each group

Selecting a record with max value on one of the joins

Find the record nearest to the datetime specified

R aggregate() by group using some function (e.g., max) but then project on other column

What SQL query can I use to get the first record of each group based on a certain column? [duplicate]

Is there a way to get 2 rows from each group of rows? [duplicate]

Getting `n` rows for each id in a result set MYSQL

Query conditionally return only one row per distinct id

Microsoft SQL Query - Return last record from second table