/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

2 votes287 views2 answers
Mysql on duplicate key ignore
SQL
0 vote296 views2 answers
Sqlite unix timestamp
SQL
2 votes270 views3 answers
Mysql cheat sheet
SQL
0 vote319 views1 answer
Postgres can integer fields be negative
SQL
1 vote322 views3 answers
Postgresql get difference between two dates
SQL
2 votes298 views1 answer
Postgresql left join distinct on
SQL
10 votes293 views1 answer
Query to find object dependencies in oracle
SQL
7 votes301 views2 answers
What is sql clause
SQL
7 votes294 views1 answer
Sql server convert string to date
SQL
0 vote302 views1 answer
Mysql calculated column
SQL