New answers tagged

0 votes
Accepted

How to display last record per parameter?

I don't know exactly what you want, but I'm guessing you want to take your aggregate data and combine it with the latest data. Are you looking for something like this? WITH AggregateData AS ( ...
user avatar
2 votes

In MySQL can I create a view of the rows with the highest number from one field?

First of all, a VIEW is just a shorthand for a SELECT. If you can write a SELECT, you can create a VIEW. Plan A: Save the "6" in a separate, one-line< table. Plan B: Write a SELECT (...
user avatar
  • 69.4k

Top 50 recent answers are included