/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 vote160 views1 answer
Sql describe
SQL
2 votes133 views1 answer
Postgresql change value in column
SQL
25 votes138 views6 answers
Import mysql database command line
SQL
-1 vote136 views3 answers
Compute age mysql
SQL
1 vote140 views1 answer
Spark sql concatenate string and int
SQL
0 vote147 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote227 views1 answer
Mysql monthname
SQL
22 votes172 views4 answers
Date format mysql
SQL
0 vote93 views1 answer
How to see the content of tables in pgadmin
SQL
7 votes137 views1 answer
Sql disable safe mode
SQL