/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 vote179 views1 answer
Drop tables from local database postgres pgadmin
SQL
8 votes170 views5 answers
Grant permission in postgres
SQL
0 vote224 views1 answer
Sql tablo sp
SQL
0 vote205 views1 answer
.sql File Run in PSQL
SQL
0 vote341 views1 answer
The differnece between to values in sql
SQL
0 vote170 views2 answers
Mysql set foreign_key_checks=0
SQL
-1 vote188 views1 answer
Count occurrences sql
SQL
0 vote182 views1 answer
Java mysql swing example
SQL
1 vote182 views2 answers
Postgres cast as decimal
SQL
2 votes180 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL