Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in greatest-n-per-group

How to return 1 row for each distinct value in a given column in Oracle? [duplicate]

In SQL Server, how to pick top 4th row?

SQL return transaction table with the date of previous payment

A query to pick out the highest ten values, or the highest 10%, from groups within a table

SQL to get unique rows in Netezza DB

Select N records for each category and order by X

retrieve the most recent record for each customer

mysql query to retrieve first 2 records for each item type

How to use SELECT DISTINCT ON with MySQL and Rails

To find Lowest Experience of any Employee by writing a query in GRID DB

SQL Server select max date per ID

Get max ID for every Type and every Date from a lookup table

Joining only one row in doctrine

Querying single oldest record for each ID

Grabbing the row with the highest value from each group?

sql greatest-n-per-group

Select random percentage from a table in Snowflake (while using the WHERE clause)

Using a WHERE clause subquery, select the greatest 1 per group with a tie-breaker

Inner join with 3 tables

Count the most recent number of consecutive rows with a null value

How to get the values for every group of the top 3 types