Thank you so much for the explanation. Is there any way that this view could be simplified to avoid using the window function? I don't mind if I have to do separate views by distance if needed. I was handled over this code and my knowledge of SQLite is very limited. The view is giving the top three racers (their bib no.) by time, for men and women, and for each of the races. Epreuve # S 3_Premiers Temps/Jour ---------- - - ---------- ---------- UTHC 125km 1 M 107 02:00 17 UTHC 125km 2 M 133 02:14 17 UTHC 125km 3 M 118 02:29 17 UTHC 125km 1 F 157 02:19 17 UTHC 125km 2 F 48 02:40 17 UTHC 125km 3 F 136 04:14 17 UTHC 80km 1 M 8116 02:12 17 UTHC 80km 2 M 8010 02:59 17 UTHC 80km 3 M 8124 03:10 17 UTHC 80km 1 F 8062 02:03 17 UTHC 80km 2 F 8034 02:15 17 UTHC 80km 3 F 8139 02:35 17 UTHC 65km 1 M 6073 02:09 17 UTHC 65km 2 M 6230 02:33 17 UTHC 65km 3 M 6178 02:36 17 UTHC 65km 1 F 6121 02:26 17 UTHC 65km 2 F 6204 02:42 17 UTHC 65km 3 F 6276 02:54 17