User and date as the primary key
Query a user traffic latest
Select rownum, user, date, flow from the table order by desc date where rownum=1 and user=* * *;

Could you tell me how to optimize the great god the

CodePudding user response:

User and date as the primary key
Query a user traffic latest
Select the user, date, flow from the table where the date=(
Select Max (date) from the table where the user==* * * * * *) and users.

CodePudding user response:

This statement is wrong grammar, to optimize what is this?

CodePudding user response:

You the zha to perform?