/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 vote298 views1 answer
How to find sql server installation folder
SQL
1 vote282 views1 answer
Postgresql how to show table names
SQL
0 vote317 views1 answer
Postgres list all triggers
SQL
0 vote222 views1 answer
Mysql select top 2
SQL
0 vote274 views1 answer
Mysql query problems and solutions
SQL
0 vote281 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote268 views1 answer
Mod in sql
SQL
4 votes272 views1 answer
What are the data types in sql
SQL
1 vote283 views1 answer
Pl sql insert into table
SQL
0 vote289 views1 answer
SQL FROM-Klausel
SQL