/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 vote288 views1 answer
Inserted row count tsql
SQL
-1 vote281 views1 answer
Mysql #1064 error
SQL
1 vote289 views1 answer
Mysql view current queries
SQL
0 vote296 views1 answer
Sql pad left 0
SQL
0 vote291 views1 answer
Sql server query database space available
SQL
1 vote302 views2 answers
Oracle list service names
SQL
4 votes308 views3 answers
Sql drop database if exists
SQL
0 vote277 views1 answer
Mysql date only no time
SQL
0 vote290 views1 answer
Order by in codeigniter query builder
SQL
0 vote276 views1 answer
Mysql xampp reset root password
SQL