/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 vote207 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
6 votes211 views1 answer
Oracle rank
SQL
0 vote222 views1 answer
How to run mysql in git bash
SQL
7 votes215 views1 answer
Oracle pagination query rownum
SQL
10 votes237 views6 answers
Mysql set root password
SQL
6 votes256 views3 answers
Check if string contains substring sql
SQL
1 vote203 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote162 views1 answer
Oracle sysdba connect as another user
SQL
0 vote193 views1 answer
How to see the query of a view in mysql
SQL
2 votes221 views1 answer
How to delete columns in sql
SQL