/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 vote102 views2 answers
Show slave status mysql
SQL
0 vote111 views1 answer
ALV GRID events
SQL
0 vote118 views1 answer
Find wordpress version in database
SQL
6 votes112 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote115 views2 answers
Postgresql get long running queries
SQL
10 votes109 views1 answer
Oracle view dependencies
SQL
15 votes115 views2 answers
Select where duplicate mysql
SQL
1 vote138 views1 answer
Continue in sql
SQL
0 vote105 views1 answer
Xampp mysql version
SQL
0 vote105 views2 answers
Sql update top 100
SQL