/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 vote152 views5 answers
Online sql to linq generator
SQL
3 votes145 views1 answer
Oracle wait
SQL
0 vote150 views1 answer
Datetime postgres typeorm
SQL
0 vote159 views1 answer
Postgres can integer fields be negative
SQL
0 vote168 views1 answer
On delete set default
SQL
27 votes154 views5 answers
Add column in table
SQL
16 votes151 views2 answers
Sql exists
SQL
0 vote187 views1 answer
Mysql command line top 10
SQL
16 votes158 views2 answers
Add column if not exists mysql
SQL
12 votes182 views6 answers
Distinct in sql server
SQL