/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 vote250 views1 answer
Table structure in sql
SQL
1 vote163 views1 answer
How to run sql script
SQL
0 vote220 views1 answer
Convert excel into sqllite db using python
SQL
0 vote207 views1 answer
How to drop columns with constraint from a table in sql script
SQL
5 votes241 views1 answer
Oracle drop index if exists
SQL
3 votes200 views1 answer
Insert into table from another table mysql
SQL
8 votes226 views2 answers
Safe update mode in mysql
SQL
2 votes218 views2 answers
How to check database username and password in postgresql
SQL
13 votes218 views6 answers
Restart postgresql
SQL
0 vote233 views1 answer
Select nth row in mysql
SQL