/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 vote168 views1 answer
Get who is hired in specific month in sql
SQL
2 votes168 views3 answers
Postgresql reset auto increment
SQL
1 vote173 views1 answer
Sql server kill all connections
SQL
0 vote177 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote167 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
6 votes183 views2 answers
Foreign key sqlite3 python
SQL
5 votes163 views2 answers
Oracle tables with column name
SQL
8 votes178 views5 answers
Alter table add column with default value
SQL
0 vote190 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote170 views1 answer
Sql cheetsheet
SQL