/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

3 votes130 views1 answer
Oracle list invalid password logon denied
SQL
0 vote91 views1 answer
Sql injection mitigation
SQL
0 vote134 views1 answer
Python dictionary to sql update
SQL
5 votes113 views1 answer
How to check nls format in oracle
SQL
0 vote131 views1 answer
Select odd records sql
SQL
0 vote105 views1 answer
Get only first row mysql
SQL
0 vote136 views1 answer
Shortcut run sql pgadmin
SQL
-2 votes128 views2 answers
Union vs union all in sql
SQL
1 vote117 views1 answer
Sql current timestamp
SQL
0 vote114 views1 answer
Mysql count by month
SQL