/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 vote254 views1 answer
TSQL function split string
SQL
0 vote266 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote260 views1 answer
How to fetch unique records from two tables
SQL
1 vote275 views1 answer
Update foreign key value in mysql
SQL
0 vote257 views1 answer
Mysql multiple group by
SQL
0 vote284 views1 answer
Oracle session statistics
SQL
-1 vote258 views1 answer
How to create foreign key in sql server management studio
SQL
2 votes274 views1 answer
Postgresql update sequence next value
SQL
0 vote245 views1 answer
Select from 3 tables one is empty
SQL
0 vote238 views1 answer
Oracle sql date summer time
SQL