/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 vote316 views1 answer
Multiple like values for single column postgres
SQL
14 votes311 views2 answers
Oracle export trigger ddl
SQL
0 vote309 views1 answer
Oracle activate program
SQL
0 vote322 views1 answer
Drop database using terminal postgres
SQL
0 vote346 views1 answer
Bigrock database connection string
SQL
7 votes318 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote302 views1 answer
Sql server port 1434
SQL
0 vote303 views1 answer
Copied text from internet not inserting in mysql
SQL
2 votes320 views1 answer
Mysql select default if null
SQL
1 vote306 views1 answer
Postgresql delete cascade
SQL