mysql选择第一行_如何选择MySQL中每个组的第一行？

在C#中它将是这样：

table

.GroupBy(row => row.SomeColumn)

.Select(group => group

.OrderBy(row => row.AnotherColumn)

.First()

)

Linq-To-Sql将其转换为以下T-SQL代码：

SELECT [t3].[AnotherColumn], [t3].[SomeColumn]

FROM (

SELECT [t0].[SomeColumn]

FROM [Table] AS [t0]

GROUP BY [t0].[SomeColumn]

) AS [t1]

OUTER APPLY (

SELECT TOP (1) [t2].[AnotherColumn], [t2].[SomeColumn]

FROM [Table] AS [t2]

WHERE (([t1].[SomeColumn] IS NULL) AND ([t2].[SomeColumn] IS NULL))

OR (([t1].[SomeColumn] IS NOT NULL) AND ([t2].[SomeColumn] IS NOT NULL)

AND ([t1].[SomeColumn] = [t2].[SomeColumn]))

ORDER BY [t2].[AnotherColumn]

) AS [t3]

ORDER BY [t3].[AnotherColumn]

但它与MySQL不兼容。