/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

5 votes190 views3 answers
String concatenation sql server
SQL
0 vote184 views2 answers
Sql server select first day of previous year
SQL
1 vote259 views1 answer
Mysql is odd
SQL
0 vote184 views1 answer
Psql check table fields
SQL
3 votes185 views1 answer
Oracle get trigger ddl
SQL
0 vote171 views1 answer
Disableforiegn key check
SQL
1 vote176 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
1 vote181 views1 answer
Mysql select from outside
SQL
3 votes206 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote174 views1 answer
Mysql get last insert id
SQL