/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 vote278 views1 answer
Query archive mode
SQL
8 votes291 views1 answer
Check mysql version phpmyadmin
SQL
0 vote278 views1 answer
Mysql conf.d exampel
SQL
-1 vote245 views10 answers
Delete Query in SQL Server
SQL
0 vote272 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote279 views1 answer
Sql delete row from table where id
SQL
0 vote294 views2 answers
Mysql set foreign_key_checks=0
SQL
7 votes272 views1 answer
Minecraft forge server host
SQL
0 vote227 views1 answer
Mysql collation for all languages
SQL
3 votes288 views1 answer
Set default today mysql
SQL