StackOverflow Questions for Tag: top-n

Johnny Metz

Reputation: 6055

PostgreSQL: SELECT DISTINCT ON expressions must match initial ORDER BY expressions

sqlpostgresqlsql-order-bygreatest-n-per-groupdistinct-on

Score: 6

Answers: 2

Ben

Reputation: 11

How to update top two rows of a table in stored procedure

mysqlstored-proceduresgreatest-n-per-group

Score: 1

Answers: 2

Yarin

Reputation: 183989

Get records with max value for each group of grouped SQL results

mysqlsqlgreatest-n-per-group

Score: 365

Answers: 21

kazinix

Reputation: 30163

Get top 1 row of each group

sqlsql-servert-sqlgreatest-n-per-group

Score: 789

Answers: 17

NALL

Reputation: 5

mysql SELECT issue with HAVING and/or WHERE

mysqlgreatest-n-per-group

Score: 0

Answers: 1

Mohammad Tanvir Ahamed

Reputation: 97

Unexpected output of dplyr::top_n

rdplyrgreatest-n-per-group

Score: 1

Answers: 1

Mahdi Majidzadeh

Reputation: 868

show last comment which just 1 comment per user

mysqlgreatest-n-per-group

Score: 0

Answers: 2

Mauricio

Reputation: 742

Not the same result between SqLite and MariaDb SELECT

mysqlsqlitemariadbsqlite-netgroupwise-maximum

Score: 1

Answers: 1

Marta

Reputation: 3863

Postgresql extract last row for each id

sqlpostgresqlgreatest-n-per-group

Score: 173

Answers: 6

Sanjay Naik

Reputation: 428

Fetch top 3 students from each subject using SQL

sqloracle-databasegreatest-n-per-group

Score: -3

Answers: 2

DiscontentDisciple

Reputation: 466

PostgreSQL Selecting Most Recent Entry for a Given ID

sqlpostgresqlgreatest-n-per-group

Score: 11

Answers: 3

Dainius

Reputation: 1

What is Excel formula to show Top N by category?

filterexcel-formulagreatest-n-per-groupspill-range

Score: 0

Answers: 0

Stephen Fuhry

Reputation: 13039

MySQL SELECT most frequent by group

mysqlgroup-bygreatest-n-per-groupfrequency

Score: 9

Answers: 6

user28577345

Reputation: 25

Top Reviewed Customers per Product

sqlmysqlgreatest-n-per-group

Score: 1

Answers: 1

Nathan Elledge

Reputation: 11

MariaDB - return 1 row of each product with 2 columns, current cost and last cost

mariadbgreatest-n-per-group

Score: 1

Answers: 1

Aurelius

Reputation: 132

In a select with a group by, get the last value of a column not in the group by

sqlsql-servergreatest-n-per-group

Score: 1

Answers: 2

LesleyJill

Reputation: 111

When a column has multiple values per user how do I select the most recent one according to date in another column?

mysqldatemaxgreatest-n-per-group

Score: 1

Answers: 0

mattesj

Reputation: 609

Get most recent row with group by and Laravel

mysqlsqllaraveleloquentgreatest-n-per-group

Score: 6

Answers: 6

Sriram Chowdary

Reputation: 23

How to choose index for complex sql queries

sqlmysqlindexinggreatest-n-per-group

Score: 0

Answers: 1

Jiew Meng

Reputation: 88387

DISTINCT ON needing Bitmap Heap Scan

sqlpostgresqlindexinggreatest-n-per-group

Score: 0

Answers: 1

PreviousPage 1Next