/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 vote123 views1 answer
Postgresql show owner of database
SQL
0 vote113 views1 answer
Sql count total by foreign key
SQL
0 vote125 views1 answer
How to create a new shema using query languaage
SQL
0 vote118 views1 answer
Sql query tags
SQL
9 votes140 views3 answers
Postgres make sql dump
SQL
1 vote146 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote129 views1 answer
Postgresql import a database of gzip
SQL
0 vote127 views1 answer
Postgres read table structure
SQL
2 votes106 views1 answer
Oracle sql drop column if exists
SQL
2 votes114 views1 answer
Mysql select random id from table
SQL