/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 vote249 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote285 views1 answer
Space not removing from column in sql
SQL
1 vote281 views1 answer
Table valued functions in sql
SQL
0 vote316 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote261 views1 answer
Mysql get last 2 month data
SQL
2 votes268 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote273 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote253 views1 answer
Like and not like together in sql
SQL
1 vote255 views1 answer
Oracle rolling back transactions
SQL
9 votes262 views5 answers
Sql limit
SQL