Tag: mariadb-10.1

Find number of rows with each property value, taking into account only the most recent rows in SQL

I have a database with tables that represents “edits” to “pages”. Every edit has an ID and a timestamp and a “status”, which has certain discrete values. Pages have IDs and also have “categories”. I wish to find the number of pages with each status within a give…

Find the longest rainless time (every hour, beyond several days)

date datetime gaps-and-islands mariadb-10.1 sql

I have a weather station where I measure the amount of rain per hour and save the data in a database. The rain-table looks like this: Now I want the longest rainless time per month. I already have a solution, but it only works for the respective day. However, if there is no rain for several days, my solution …

MySQL how to get 2nd most recent record in linked table in search query [closed]

mariadb-10.1 mysql sql

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question I have a MySQL DB with two linked tables Products and Price History. They are linked by a pr…