Redis Keys: SORT
SORT key [BY pattern] [LIMIT offset count] [GET pattern [GET pattern ...]] [ASC | DESC] [ALPHA] [STORE destination]
The usage is simple sort key.
Here you write with a key data type is a list, set, sorted set.
data (member) to put the data on the sort not seen, let's set sort.
Syntax:
SORT key [BY pattern] [LIMIT offset count] [GET pattern [GET pattern ...]] [ASC | DESC] [ALPHA] [STORE destination]
Available since
1.0.0.
Return Value
Returns or stores the elements contained in the list, set or sorted set at the key. By default, sorting is numeric and elements are compared by their value interpreted as double precision floating point number.
- Since in the second call, the returned cursor is 0
- SCAN until the returned cursor is 0 again
Return Value Type
Integer
Example: Redis SORT alpha
127.0.0.1:6379> SADD xurl Facebook.com Buddy.com Yahoo.com Youtube.com Example.com (integer) 5 127.0.0.1:6379> SORT xurl alpha 1) "Buddy.com" 2) "Example.com" 3) "Facebook.com" 4) "Yahoo.com" 5) "Youtube.com"
Example: Redis SORT alpha desc
127.0.0.1:6379> SORT xurl alpha desc 1) "Youtube.com" 2) "Yahoo.com" 3) "Facebook.com" 4) "Example.com" 5) "Buddy.com"
Example: Redis SORT limit offset count
127.0.0.1:6379> SORT xurl alpha limit 0 3 1) "Buddy.com" 2) "Example.com" 3) "Facebook.com" 127.0.0.1:6379> SORT xurl alpha limit 0 10 1) "Buddy.com" 2) "Example.com" 3) "Facebook.com" 4) "Yahoo.com" 5) "Youtube.com" 127.0.0.1:6379> SORT xurl alpha limit 3 10 1) "Yahoo.com" 2) "Youtube.com"
Use get option
If you get used to query the value of the other key
For example, when compared to Google.com and rank-Google.com of xurl to query the value of the use rank-Google.com get rank-*.
If you are thinking to join in a relational database.
Enter the web site ranking to prepare data
Example: Redis SORT rank-* alpha
127.0.0.1:6379> MSET rank-Google.com 1 rank-Facebook.com 2 rank-Youtube.com 3 rank-Buddy.com 4 rank-Example.com 5 OK 127.0.0.1:6379> SORT xurl get rank-* alpha 1) "4" 2) "5" 3) "2" 4) "1" 5) "3"
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join