/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 vote105 views1 answer
Longtext sql
SQL
3 votes122 views1 answer
Define REGEXP?
SQL
0 vote98 views1 answer
Oracle locked objects
SQL
0 vote108 views1 answer
Convert int to varchar sql
SQL
0 vote102 views1 answer
Sql case sttement with set
SQL
0 vote115 views1 answer
Create database like
SQL
0 vote64 views1 answer
Prevent duplicate rows in postgres
SQL
6 votes107 views3 answers
Mysql first day of year
SQL
0 vote120 views1 answer
What is common table expression in sql
SQL
0 vote98 views1 answer
Get yesterday date ISO in psql
SQL