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 given category, taking into account only the state as of the most recent
Tag: mariadb-10.1
Find the longest rainless time (every hour, beyond several days)
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 will
MySQL how to get 2nd most recent record in linked table in search query [closed]
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 productID field. Each time the price of