/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 vote161 views1 answer
C# select Mysql
SQL
0 vote132 views1 answer
Postgres copy command
SQL
0 vote135 views1 answer
Sql alter table order by
SQL
0 vote140 views1 answer
Oracle procedure teamplate
SQL
1 vote141 views2 answers
Begin transaction sql
SQL
0 vote134 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote136 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote142 views1 answer
How to input data as id in database sql c#
SQL
6 votes133 views1 answer
What is where clause in sql
SQL
0 vote130 views1 answer
Run sql script file and changes db name in this file using c#
SQL