/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

1 vote172 views1 answer
Update and replace mysql
SQL
0 vote133 views1 answer
Mysql collation for all languages
SQL
0 vote192 views1 answer
Postgres row expiration
SQL
0 vote173 views1 answer
Use between operator in mysql
SQL
1 vote195 views1 answer
Postgresql define pk sequence next number
SQL
11 votes173 views2 answers
Docker create postgres db
SQL
0 vote201 views3 answers
Characters found after end of sql statement
SQL
1 vote174 views3 answers
Epoch to datetime
SQL
15 votes189 views6 answers
Psql
SQL
0 vote168 views1 answer
10000000000000000000 am to meters
SQL