/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 vote249 views2 answers
Oracle ora-00054 how to unlock
SQL
1 vote220 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote257 views1 answer
Get initials name in sql
SQL
2 votes254 views1 answer
Sql update \
SQL
1 vote265 views1 answer
Primary key with prefix sql
SQL
0 vote224 views2 answers
Mysql slave status
SQL
4 votes247 views2 answers
Oracle last day of month
SQL
0 vote250 views1 answer
Will graphql replace sql
SQL
0 vote252 views1 answer
Mssql dockere
SQL
0 vote225 views1 answer
Mysql_num_fields in mysqli
SQL