MySQL ORDER BY
Natijani tartiblang
Natijani o‘sish yoki kamayish tartibida tartiblash uchun ORDER BY iborasidan foydalaning.
ORDER BY kalit so‘zi natijani sukut bo‘yicha o‘sish bo‘yicha tartiblaydi. Natijani kamayish tartibida saralash uchun DESC kalit so‘zidan foydalaning.
Misol
Natijani nomi bo‘yicha alifbo tartibida tartiblang: natija:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="mydatabase"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM customers ORDER BY name"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
print(x)
Misolni ishga tushirish »
ORDER BY DESC
Natijani kamayish tartibida tartiblash uchun DESC kalit so‘zidan foydalaning.
Misol
Natijani nomi bo‘yicha alifbo tartibida teskari tartiblang:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="mydatabase"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM customers ORDER BY name DESC"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
print(x)
Misolni ishga tushirish »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!