/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 vote152 views1 answer
Update sql join multiple tables
SQL
-1 vote204 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote214 views1 answer
Postgresql isnull with max
SQL
0 vote196 views2 answers
How to combine diff colmun value using group by postgres
SQL
4 votes226 views3 answers
NOT NULL SQL
SQL
0 vote213 views2 answers
Sql query in dax power bi
SQL
0 vote269 views1 answer
Bash block size ls /var/lib/mysql
SQL
10 votes204 views1 answer
Oracle object dependencies
SQL
16 votes216 views3 answers
T-SQL Add Column
SQL
0 vote206 views4 answers
Sql rownum
SQL