Search code examples
SELECT rows with the max count per column value after GROUP BY...


sqlpostgresqlaggregategreatest-n-per-group

Read More
SQL SELECT TOP 1 FOR EACH GROUP...


sqlsql-servergreatest-n-per-group

Read More
Simple Query to Grab Max Value for each ID...


sqlsql-servermaxgreatest-n-per-group

Read More
Select top 15 records from each group...


sqlpaginationfilteringgreatest-n-per-grouporacle-database

Read More
SQL select only rows with max value on a column...


mysqlsqlaggregate-functionsgreatest-n-per-groupgroupwise-maximum

Read More
SELECT posts and their comments...


sqlpostgresqljoingreatest-n-per-group

Read More
Postgres query table with max value in row with group by...


sqlpostgresqlgreatest-n-per-group

Read More
Returning top value with associated columns...


sqloraclegreatest-n-per-group

Read More
Grouping query based on one column in Oracle...


oraclegroup-bygreatest-n-per-groupmin

Read More
SQL query to get hourly data for highest revision number per day...


sqlpostgresqlgreatest-n-per-group

Read More
How to select collection of records, but only one per subgroup, in SQL?...


sqlpostgresqlgreatest-n-per-group

Read More
ROW_NUMBER() in MySQL...


mysqlsqlgreatest-n-per-grouprankrow-number

Read More
Getting only one row of data per primary key when there are many foreign keys that equals it...


sqlsql-serverjoinstored-proceduresgreatest-n-per-group

Read More
ORACLE - Limit number of rows for specific column value...


sqloraclegreatest-n-per-group

Read More
Get top 1 row of each group...


sqlsql-servert-sqlgreatest-n-per-group

Read More
Fetch the rows which have the Max value for a column for each distinct value of another column...


sqloraclegreatest-n-per-group

Read More
Get top results for each group (in Oracle)...


sqloraclegreatest-n-per-group

Read More
How to select the last record of each ID...


sqlpostgresqlgreatest-n-per-group

Read More
How to group following rows by not unique value...


sqlpostgresqlgreatest-n-per-groupwindow-functionsgaps-and-islands

Read More
How to aggregate for first values in group...


sqlpostgresqlgreatest-n-per-grouppostgresql-9.5aggregate-filter

Read More
List of all the Last People to Enter the Elevator...


sqlsql-servergreatest-n-per-group

Read More
Find N latest rows for each row in the main table...


sqlpostgresqlgreatest-n-per-grouppostgresql-13

Read More
Two Categorical Variables, Sorting and displaying top_15 in ggplot...


rsortingggplot2greatest-n-per-groupgeom-bar

Read More
Find first 3 orders for each customer...


sqlpostgresqlgreatest-n-per-groupsql-limit

Read More
Selecting the most recent, lowest price from multiple vendors for an inventory item...


mysqlsqlpostgresqlgreatest-n-per-groupdistinct-on

Read More
Power BI: Column chart with both top and bottom...


powerbidaxgreatest-n-per-groupcolumn-chart

Read More
Select second most minimum value in Oracle...


sqloracleoracle11ggreatest-n-per-group

Read More
Get top n records for each group of grouped results...


mysqlsqlgreatest-n-per-groupmysql-variables

Read More
How to SELECT the newest four items per category?...


sqlmysqlgreatest-n-per-group

Read More
MySQL LEFT JOIN only 1 row depending on MAX() value...


mysqlgreatest-n-per-group

Read More
BackNext