Ranked SQL arrangement obtaining method and device and computer equipment
The invention discloses a ranked SQL arrangement obtaining method and device, computer equipment and a storage medium, and the method comprises the steps: receiving an SQL sorting instruction for specified data, calling the specified data from a database, and sorting the specified data in a sorting...
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Patent |
| Sprache: | chi ; eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | The invention discloses a ranked SQL arrangement obtaining method and device, computer equipment and a storage medium, and the method comprises the steps: receiving an SQL sorting instruction for specified data, calling the specified data from a database, and sorting the specified data in a sorting mode through a sorting field; if the specified data with the same content of the sorting field exists, dynamically recording the rank of the specified data with the same content of the sorting field as the rank +1 of the specified data in front of the specified data with the same content of all thesorting fields; and dynamically recording the ranking of other specified data except the specified data with the same content of the sorting field as the ranking +1 of the specified data of the previous bit of the other specified data so as to obtain the SQL arrangement with the ranking. Therefore, the data with the same numerical value can be sorted, and the method is compatible with data of different databases.
本申请揭示了一种 |
|---|