Open wbijker opened 4 years ago
And option to expand or create own. Commonly used queries.
Select whole record for all maximum entries: Select category_id, max("date") from table group by "category_id" inner join table on a.data = b.date
_db.table.SingleAggregate(t => t.id, t => t.category_id, t => SqlExpression.Aggregate(MAX, c => c.date));
And option to expand or create own. Commonly used queries.
Select whole record for all maximum entries: Select category_id, max("date") from table group by "category_id" inner join table on a.data = b.date
_db.table.SingleAggregate(t => t.id, t => t.category_id, t => SqlExpression.Aggregate(MAX, c => c.date));