/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

1 vote122 views2 answers
Postgres copy table from one schema to another
SQL
0 vote137 views1 answer
How to access to mysql without root
SQL
8 votes134 views1 answer
Oracle search text in all packages
SQL
0 vote113 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
12 votes131 views2 answers
Delete all entries postgres
SQL
21 votes128 views5 answers
Oracle all tables
SQL
24 votes132 views5 answers
Import dump mysql
SQL
2 votes113 views1 answer
Mysql list users on ubuntu
SQL
5 votes127 views1 answer
Add column table sql default value
SQL
0 vote119 views1 answer
Insert into using contant values and source table columns with sql
SQL