SQLite Forum

Help speeding up a query
Login
Yes, indeed.  Here is the actual code:
```
sqlite> SELECT *, max(InsertDate)
   ...>     FROM Project_List
   ...>    WHERE ProjID IN (SELECT DISTINCT ProjID FROM Project_List WHERE Project_Name LIKE '%agr-2020%')
   ...> GROUP BY ProjID;
PR0000015542|6687299|..
..
..LICATIONS|e608313|2020-04-15_08-47-09|Waterfall|2020-04-15_08-47-09
Run Time: real 0.671 user 0.109375 sys 0.359375
sqlite>
```

This is perfect, Keith.  Once again.  Thanks.

josé<br><br>
PS: I am glad you're here...  Thanks.