/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 vote108 views1 answer
Sqlserver now
SQL
1 vote92 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
5 votes116 views1 answer
Oracle nls instance
SQL
0 vote101 views1 answer
Pagination with row_number
SQL
10 votes97 views1 answer
Create table oracle
SQL
14 votes103 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
8 votes136 views1 answer
Racle create auto increment column
SQL
0 vote112 views1 answer
Sql select where more than one record exists
SQL
0 vote98 views1 answer
Print orcale
SQL
0 vote105 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL