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
The default port number of the Windows server rem...
First look at the effect: Code: 1.html <div cl...
mysql returns Boolean type In the first case, ret...
1. Floating layout 1. Let the fixed width div flo...
Preface 1. Debounce: After a high-frequency event...
HTML provides five space entities with different ...
Preface Here are the steps to install and configu...
HTML is made up of tags and attributes, which are...
In MySQL operation and maintenance, a R&D col...
0. New operation: mkdir abc #Create a new folder ...
Table of contents 1. Introduction 2. Interface 3....
Detailed explanation of MySQL instance with SSD s...
In the previous article, we learned about the pas...
Table of contents Introduction to Docker Docker e...
The img tag in XHTML is so-called self-closing, w...