Filter Rows based on time stamp data from access control

Ask a question
1

Hello, i have an MSSQL that i have connected in one of my flows, and in that table is a bunch of student IDCard swipe-on card reader details. The table contains the event time and ID card number, but i am trying to figure out a way i can find out the earliest event time for that ID and the last event time for that ID. What is the cleanest way to do this ?

Thanks
Anto

2

I see, on closer look, find by min & max could work i think right