/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

9 votes231 views1 answer
Oracle get table schema
SQL
36 votes248 views3 answers
Add column in mysq
SQL
2 votes216 views1 answer
Sql ignore accents
SQL
6 votes233 views6 answers
Count mysql
SQL
0 vote241 views1 answer
Sql statement show all emails with dome
SQL
12 votes230 views4 answers
Psql command not found
SQL
13 votes229 views2 answers
Sql count distinct group by
SQL
7 votes246 views1 answer
Sql pagination oracle
SQL
3 votes230 views2 answers
To_char oracle
SQL
2 votes256 views3 answers
Postgres json to string
SQL