/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 vote193 views1 answer
What is between keyword used for
SQL
4 votes253 views1 answer
Alter session set nls_date_format
SQL
0 vote207 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote193 views1 answer
Update having mysql
SQL
0 vote188 views1 answer
Case insensitive sql
SQL
0 vote183 views1 answer
Add multiple field in table sql
SQL
1 vote179 views1 answer
Deleting database in sql
SQL
0 vote207 views2 answers
Mysql insert into multiple tables
SQL
9 votes226 views1 answer
Identity insert on sql server
SQL
-1 vote199 views1 answer
Ssms connect with connection string
SQL