MySQL ORDER BY
Natijani tartiblang
Natijani o‘sish yoki kamayish tartibida saralash uchun ORDER BY operatoridan foydalaning.
ORDER BY kalit so‘zi natijani sukut bo‘yicha o‘sish bo‘yicha tartiblaydi. Saralash uchun natija kamayish tartibida bo‘lsa, DESC kalit so‘zidan foydalaning.
Misol
Natijani nomi bo‘yicha alifbo tartibida tartiblang:
let mysql = require('mysql');
let con = mysql.createConnection({
host: "localhost",
user: "yourusername",
password: "yourpassword",
database: "mydb"
});
con.connect(function(err) {
if (err) throw err;
con.query("SELECT * FROM customers ORDER BY name", function (err, result) {
if (err) throw err;
console.log(result);
});
});
Misolni ishga tushirish »
Yuqoridagi kodni "demo_db_orderby.js" nomli faylga saqlang va faylni ishga tushiring:
"demo_db_orderby.js" ni ishga tushiring
C:\Users\Your Name>node demo_db_orderby.js
Bu sizga bu natijani beradi:
[
{ id: 3, name: 'Amy',
address: 'Apple st 652'},
{ id: 11, name: 'Ben', address: 'Park Lane 38'},
{ id: 7,
name: 'Betty', address: 'Green Grass 1'},
{ id: 13, name: 'Chuck', address:
'Main Road 989'},
{ id: 4, name: 'Hannah', address:
'Mountain 21'},
{ id: 1, name: 'John', address: 'Higheay 71'},
{ id: 5, name: 'Michael', address: 'Valley 345'},
{ id:
2, name: 'Peter', address: 'Lowstreet 4'},
{ id: 8, name: 'Richard',
address: 'Sky st 331'},
{ id: 6, name: 'Sandy', address: 'Ocean blvd 2'},
{ id: 9, name: 'Susan', address: 'One way
98'},
{ id: 10, name: 'Vicky', address: 'Yellow Garden 2'},
{ id: 14, name: 'Viola', address: 'Sideway
1633'},
{ id: 12, name: 'William',
address: 'Central st 954'}
]
DESC BUYUK BUYURTMA
Natijani kamayish tartibida tartiblash uchun DESC kalit so‘zidan foydalaning.
Misol
Natijani nomi bo‘yicha alifbo tartibida teskari tartiblang:
let mysql = require('mysql');
let con = mysql.createConnection({
host: "localhost",
user: "yourusername",
password: "yourpassword",
database: "mydb"
});
con.connect(function(err) {
if (err) throw err;
con.query("SELECT * FROM customers ORDER BY name DESC", function (err, result) {
if (err) throw err;
console.log(result);
});
});
Misolni ishga tushirish »
Yuqoridagi kodni "demo_db_orderby_desc.js" nomli faylga saqlang va faylni ishga tushiring:
"demo_db_orderby_desc.js" ni ishga tushiring
C:\Users\Your Name>node demo_db_orderby_desc.js
Bu sizga bu natijani beradi:
[
{ id: 12, name: 'William',
address: 'Central st 954'},
{ id: 14, name: 'Viola', address: 'Sideway
1633'},
{ id: 10, name: 'Vicky', address: 'Yellow Garden 2'},
{ id: 9, name: 'Susan', address: 'One way
98'},
{ id: 6, name: 'Sandy', address: 'Ocean blvd 2'},
{ id: 8, name: 'Richard',
address: 'Sky st 331'},
{ id:
2, name: 'Peter', address: 'Lowstreet 4'},
{ id: 5, name: 'Michael', address: 'Valley 345'},
{ id: 1, name: 'John', address: 'Higheay 71'},
{ id: 4, name: 'Hannah', address:
'Mountain 21'},
{ id: 13, name: 'Chuck', address:
'Main Road 989'},
{ id: 7,
name: 'Betty', address: 'Green Grass 1'},
{ id: 11, name: 'Ben', address: 'Park Lane 38'},
{ id: 3, name: 'Amy',
address: 'Apple st 652'}
]
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!