How to select the first row for each group in MySQL?

by

I based my answer on the title of your post only, as I don’t know C# and didn’t understand the given query. But in MySQL I suggest you try subselects. First get a set of primary keys of interesting columns then select data from those rows:

SELECT somecolumn, anothercolumn 
  FROM sometable 
 WHERE id IN (
               SELECT min(id) 
                 FROM sometable 
                GROUP BY somecolumn
             );

More Related Contents:

  1. Using LIMIT within GROUP BY to get N results per group?
  2. Error related to only_full_group_by when executing a query in MySql
  3. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  4. MySQL Query GROUP BY day / month / year
  5. MySQL order by before group by
  6. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  7. Grouping into interval of 5 minutes within a time range
  8. Retrieving the last record in each group – MySQL
  9. MySQL – Selecting a Column not in Group By
  10. Mysql query to dynamically convert rows to columns
  11. MySQL “Group By” and “Order By”
  12. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  13. MySQL – Control which row is returned by a group by
  14. SQL Query to get column values that correspond with MAX value of another column?
  15. MySQL Order before Group by
  16. MySQL Group By and Sum total value of other column
  17. What does SQL clause “GROUP BY 1” mean?
  18. Using ORDER BY and GROUP BY together
  19. MySQL – Fetching lowest value
  20. ORDER BY date and time BEFORE GROUP BY name in mysql
  21. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  22. MySQL GROUP BY DateTime +/- 3 seconds
  23. Sum results of a few queries and then find top 5 in SQL
  24. Select all months within given date span, including the ones with 0 values
  25. sql group by versus distinct
  26. MySQL Group By Hours
  27. MySQL cumulative sum grouped by date
  28. Select only last value using group by at mysql
  29. group by range in mysql
  30. SQL query with avg and group by

Leave a Comment