SyntaxFix

[mysql] GROUP BY having MAX date

There's no need to group in that subquery... a where clause would suffice:

SELECT * FROM tblpm n
WHERE date_updated=(SELECT MAX(date_updated)
    FROM tblpm WHERE control_number=n.control_number)

Also, do you have an index on the 'date_updated' column? That would certainly help.

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to optimization

• Why does C++ code for testing the Collatz conjecture run faster than hand-written assembly? • Measuring execution time of a function in C++ • GROUP BY having MAX date • How to efficiently remove duplicates from an array without using Set • Storing JSON in database vs. having a new column for each key • Read file As String • How to write a large buffer into a binary file in C++, fast? • Is optimisation level -O3 dangerous in g++? • Why is processing a sorted array faster than processing an unsorted array? • MySQL my.cnf performance tuning recommendations

Examples related to greatest-n-per-group

• How to select the rows with maximum values in each group with dplyr? • MAX function in where clause mysql • Pandas get topmost n records within each group • SQL Left Join first match only • Select info from table where row has max date • FORCE INDEX in MySQL - where do I put it? • GROUP BY having MAX date • How can I select rows with most recent timestamp for each key value? • Select row with most recent date per user • How to select id with max date group by category in PostgreSQL?