Re: [sqlite] Limit to 5 records per Group / Top N results per group

2016-06-01 Thread Igor Tandetnik
On 6/1/2016 5:36 PM, Russell, Rory wrote: In SQLIte, I have 2 tables, one is for a list of Projects (about 50 projects) and the other is a list of key dates for each project. Each project has about 20 key dates. How can run a query that will only return the top/first 5 dates for each project in

[sqlite] Limit to 5 records per Group / Top N results per group

2016-06-01 Thread Russell, Rory
All, Please help.I have been trying but can't find an answer. In SQLIte, I have 2 tables, one is for a list of Projects (about 50 projects) and the other is a list of key dates for each project. Each project has about 20 key dates. How can run a query that will only return the top/first 5 dat