/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 vote169 views1 answer
Mysql export data with a where clause
SQL
2 votes146 views1 answer
Set username and password for postgresql database
SQL
4 votes190 views1 answer
Select first and last row sql
SQL
0 vote142 views1 answer
Add sqlite3 in lumen
SQL
1 vote169 views1 answer
Print year of a date sql
SQL
1 vote137 views1 answer
Deleting database in sql
SQL
0 vote152 views1 answer
Mysql coonect sample code
SQL
0 vote139 views1 answer
Mysql user set plugin
SQL
0 vote153 views1 answer
How to use lower case in mysql
SQL
0 vote137 views1 answer
Sql datediff db2
SQL