/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 vote405 views1 answer
Postgres left join
SQL
1 vote354 views3 answers
Psql fatal database does not exist
SQL
6 votes352 views1 answer
Update left join mysql
SQL
0 vote370 views1 answer
What does leave do in mysql
SQL
0 vote357 views1 answer
Dasebase_url-postgres for windows
SQL
5 votes392 views1 answer
Purge undo tablespace usage
SQL
1 vote389 views1 answer
Sql select whole row max column
SQL
1 vote365 views1 answer
Mysql view current queries
SQL
3 votes363 views1 answer
Sql server version query
SQL
13 votes370 views3 answers
Sql select from multiple tables without join
SQL