/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 votes187 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
2 votes207 views1 answer
Mysql shell insert into
SQL
0 vote173 views2 answers
Oracle chain rules
SQL
0 vote166 views1 answer
Mysql drop multiple tables at once
SQL
2 votes228 views2 answers
Create table mysql integer NOT null
SQL
3 votes213 views2 answers
Wp do sql query from function
SQL
0 vote177 views1 answer
Sql select all records from all tables where not empty
SQL
13 votes165 views4 answers
Mysql select last 10 rows
SQL
0 vote168 views2 answers
Sql last updated
SQL
3 votes171 views3 answers
Raw select laravel
SQL