/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 vote169 views1 answer
Sql server rtrim everything after character
SQL
0 vote154 views1 answer
Value of sold product using having and group by in sql
SQL
5 votes148 views3 answers
Postgres show databases
SQL
2 votes137 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote150 views1 answer
Oracle array
SQL
0 vote158 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote183 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote147 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
1 vote149 views2 answers
Sql where keyword
SQL
0 vote140 views1 answer
Soql more than today
SQL