/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

58 votes302 views4 answers
Mysql drop column
SQL
9 votes139 views5 answers
Sql delete duplicate rows but keep one
SQL
7 votes134 views2 answers
Get database size mysql
SQL
0 vote128 views1 answer
How to install postgresql on wsl
SQL
0 vote121 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote136 views1 answer
Sql last 3 rows
SQL
0 vote132 views7 answers
10 random questions use python and SQL
SQL
0 vote188 views1 answer
Scheduled mysql database backup in linux
SQL
6 votes88 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote144 views1 answer
UseSqlServer no definition
SQL