/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

37 votes447 views6 answers
Mysql update
SQL
0 vote364 views1 answer
Mysql shell ERROR: Not connected.
SQL
1 vote365 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote344 views1 answer
Left join in codeigniter query builder
SQL
0 vote403 views1 answer
Mysql sum per week
SQL
0 vote386 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote361 views4 answers
Sql now
SQL
0 vote364 views1 answer
Difference between 2 query results sql server
SQL
19 votes374 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote304 views1 answer
Calculate discount from original price sql
SQL