/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 votes261 views1 answer
Merge two columns in sql oracle
SQL
1 vote198 views1 answer
Postgresql how to show table names
SQL
1 vote189 views1 answer
Mysql check if string contains comma separated
SQL
0 vote196 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
1 vote192 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote211 views3 answers
Run sql command line
SQL
0 vote227 views2 answers
SQL Server Standard
SQL
2 votes210 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote266 views1 answer
Create dabase postgresql
SQL
9 votes243 views1 answer
No sql
SQL