/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 vote310 views1 answer
Jdbc sql connection string
SQL
7 votes322 views2 answers
Html to react converter
SQL
0 vote310 views1 answer
Data types mysql vs postgresql
SQL
0 vote292 views1 answer
Clone table structure mysql
SQL
0 vote261 views0 answer
How to connect to datbase in springboot
SQL
6 votes342 views2 answers
Mysql concatenate two columns into one
SQL
0 vote322 views1 answer
Less than date query sqlachemy
SQL
0 vote382 views1 answer
Selecting specific day in colum sql
SQL
0 vote327 views1 answer
Datagrip execute procedure
SQL
0 vote322 views1 answer
Sql server create constraint
SQL