/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

2 votes129 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote194 views1 answer
Tsql find procedure with name
SQL
0 vote146 views1 answer
Mysql docker image arjun
SQL
-1 vote136 views1 answer
Mysql order by on condition
SQL
1 vote138 views1 answer
Table information in sql server
SQL
0 vote151 views1 answer
How to read the potentail error messages in ssis package
SQL
1 vote136 views1 answer
Right outer vs left outer join
SQL
5 votes172 views4 answers
Restart the psql server windows
SQL
4 votes241 views6 answers
Laravel jwt
SQL
0 vote150 views2 answers
Uninstall postgresql mac
SQL