Query the row with the greatest/least value per group.
I have a table with id, year and count. I want to get the MAX(count) for each id and …
sql postgresql group-by max greatest-n-per-groupI have a table as following: NAME SCORE ----------------- willy 1 willy 2 willy 3 zoe 4 zoe 5 zoe 6 Here's the sample The aggregation …
mysql sql group-by greatest-n-per-groupI am facing a rather interesting problem. I have a table with the following structure: CREATE TABLE [dbo].[Event] ( Id …
sql-server-2008 tsql sql-server-2005 greatest-n-per-groupSay I have a table "transactions" that has columns "acct_id" "trans_date" and "trans_type" and I want to …
sql greatest-n-per-groupBy using libpq on PG 9.1, I am trying to write query to get values from row with highest index 'my_…
sql postgresql greatest-n-per-groupI have a table that lists the versions of software that are installed: id | userid | version | datetime ----+--------+---------+…
sql sql-server-2012 group-by greatest-n-per-groupI have a bit of SQL that is almost doing what I want it to do. I'm working with three …
sql sql-server sql-server-2000 greatest-n-per-groupI have a table like this: Column | Type | Modifiers ---------+------+----------- country | text | food_id | int | eaten | date | And …
sql postgresql greatest-n-per-groupOK I have a table like this: ID Signal Station OwnerID 111 -120 Home 1 111 -130 Car 1 111 -135 Work 2 222 -98 Home 2 222 -95 …
sql sql-server max greatest-n-per-groupI have the following log table for user messages (simplified form) in Postgres 9.2: CREATE TABLE log ( log_date DATE, user_…
sql postgresql indexing greatest-n-per-group postgresql-performance