#aggregate-functions

[goodanswerbiz]

Fixed SQL Select only rows with Max Value on a Column #dev #it #asnwer

Fixed SQL Select only rows with Max Value on a Column #dev #it #asnwer

SQL Select only rows with Max Value on a Column

I have this table for documents (simplified version here):

++-++ | id | rev | content | ++-++ | 1 | 1 | ... | | 2 | 1 | ... | | 1 | 2 | ... | | 1 | 3 | ... | ++-++

How do I select one row per id and only the greatest rev? With the above data, the result should contain two rows: [1, 3, ...] and [2, 1, ..]. I’m using MySQL.

Currently I use checks in…

View On WordPress

[sevennet-blog]

How to: Get top 1 row of each group

How to: Get top 1 row of each group

Get top 1 row of each group

I have a table which I want to get the latest entry for each group. Here’s the table:

DocumentStatusLogs Table

|ID| DocumentID | Status | DateCreated | | 2| 1 | S1 | 7/29/2011 | | 3| 1 | S2 | 7/30/2011 | | 6| 1 | S1 | 8/02/2011 | | 1| 2 | S1 | 7/28/2011 | | 4| 2 | S2 | 7/30/2011 | | 5| 2 | S3 | 8/01/2011 | | 6| 3 | S1 | 8/02/2011 |

The table will be grouped by…

View On WordPress

[sevennet-blog]

How to: SQL Select only rows with Max Value on a Column

How to: SQL Select only rows with Max Value on a Column

SQL Select only rows with Max Value on a Column

I have this table for documents (simplified version here):

++-++ | id | rev | content | ++-++ | 1 | 1 | ... | | 2 | 1 | ... | | 1 | 2 | ... | | 1 | 3 | ... | ++-++

How do I select one row per id and only the greatest rev? With the above data, the result should contain two rows: [1, 3, ...] and [2, 1, ..]. I’m using MySQL.

Currently I use checks in…

View On WordPress