I recently encountered a problem when doing IM, and used these three keywords at the same time. It is to query the offline message details of a person. The details returned by our server to the client include three contents. The first one requires to list which people or groups have sent you messages during the offline period. The second one is how many offline messages a certain person or group has sent. The third one is to display the latest one. Obviously, group by groups which people or groups have sent you offline messages, count() gets the number of offline messages, and order by time sorts to get the latest messages. Then, as expected, an error occurs when searching with group by and order by together. We can use nested subqueries. We can group and calculate the number of results that have already been sorted. There is a hidden pit here, which I accidentally avoided. In fact, count() will cause the order by sort to be invalid. For example: The statement finally obtains a record in which msg_data is actually not sorted at all, that is, the original order of the database. It should be the message that was inserted first, that is, the old message. To avoid this problem, the nested subquery is sorted first and then count() is used to avoid it. I dodged it unintentionally, but I discovered it after I modified the sentence and tested it again and again. You may also be interested in:
|
<<: WeChat applet to achieve the revolving lantern effect example
>>: A complete example of Vue's multi-level jump (page drill-down) function for related pages
This article example shares the specific code of ...
Table of contents Standards for smooth animation ...
Table of contents 1. Install the proxy module 2. ...
Each time tomcat is started, the following log fi...
Docker is an open source container engine that he...
Table of contents 1. We must ensure that the vue/...
x-ua-compatible is used to specify the model for ...
Table of contents Case Study Update account balan...
Today I have nothing to do, so I listed some tool...
The 404 problem occurs in the Tomcat test. The pr...
Enter net start mysql in cmd and the prompt is: T...
I am currently developing a new app project. This...
Using the Docker run command docker run -d -p 920...
Container is another core concept of Docker. Simp...
1. First, you need to use the target selector of ...