/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 vote333 views1 answer
RowDataPacket
SQL
0 vote277 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote332 views1 answer
Select all tables linked server sql
SQL
0 vote393 views1 answer
Sql show founctions
SQL
2 votes366 views6 answers
Mysql change timezone
SQL
19 votes347 views6 answers
Sql drop table if exists
SQL
15 votes345 views1 answer
Mysql int range
SQL
0 vote339 views1 answer
Select 1 from orders
SQL
0 vote337 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote355 views1 answer
Oracle sql copy table without data
SQL