/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

1 vote231 views2 answers
Select into temp table
SQL
0 vote188 views1 answer
Normalization in database
SQL
0 vote201 views2 answers
Mysql dump structure only
SQL
1 vote184 views1 answer
Mysql get domain from url
SQL
2 votes168 views1 answer
Oracle sql drop table purge
SQL
0 vote237 views2 answers
Suse stop MySQL
SQL
0 vote257 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
7 votes179 views3 answers
How to check table name in current database sql
SQL
0 vote199 views1 answer
Cube oracle
SQL
0 vote180 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL