/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

15 votes320 views3 answers
Create table with primary key auto increment in sql
SQL
8 votes340 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote326 views1 answer
Sql server concat null
SQL
11 votes334 views1 answer
Get ddl materialized view oracle
SQL
5 votes306 views1 answer
Oracle ora-00054 causes
SQL
0 vote344 views1 answer
Sql date time query find
SQL
0 vote320 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote322 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote322 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote350 views4 answers
Open mysql port bitnami tomact
SQL