/SQL/Sql select first and last record of each group

Sql select first and last record of each group

select v.*
from (select v.*,
             row_number() over (partition by vehicleid, tripid order by datetime asc) as seqnum_asc,
             row_number() over (partition by vehicleid, tripid order by datetime desc) as seqnum_desc
      from vehicles v
     ) v
where seqnum_asc = 1 or seqnum_desc = 1;

Similar codes

0 vote345 views1 answer
Select last N rows mysql
SQL
4 votes347 views1 answer
Id primary key auto generated
SQL
1 vote371 views1 answer
Primary key with prefix sql
SQL
0 vote346 views1 answer
Fast sql column count
SQL
0 vote357 views1 answer
Sql server on mac m1
SQL
-1 vote374 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote356 views1 answer
Sql where part of string match
SQL
0 vote345 views1 answer
How to use select union and loop
SQL
0 vote328 views1 answer
Check index sql server
SQL
0 vote354 views1 answer
Value of sold product using having and group by in sql
SQL