ORDER BY yana watsawa sarurun sakonnin; LIMIT (tare da OFFSET) yana iyakance nawa sarurun da za a dawo. A tare suna gudanar da watsawa da pagination — abubuwa da dole ne don nuni da tsarin, sarurun shafuka.
name, age users age;
name, age users age ;
users country, name;
users created_at ;
ORDER BY yana watsawa da jeri ɗaya ko fiye, na sama (tsagaye) ko DESC. Jerin da yawa suna bayar da kariya (watsawa da na farko, sannan na biyu don daidai na ƙima).
SELECT * FROM users ORDER BY name LIMIT 10; -- the first 10 rows
SELECT * FROM users ORDER BY name LIMIT 10 OFFSET 20; -- skip 20, take 10 (page 3)
-- (syntax varies: MySQL/Postgres use LIMIT/OFFSET; SQL Server uses TOP / OFFSET-FETCH)
LIMIT n yana dawo da kusan n sarurun; OFFSET m yana tsallake na farko m. A tare suna aiwatar da offset pagination (shafuka N = LIMIT pageSize OFFSET (N-1)*pageSize).
-- ❌ LIMIT without ORDER BY → row order is UNDEFINED (inconsistent pages!)
SELECT * FROM users LIMIT 10;
-- ✅ always ORDER BY a stable column for consistent pagination
SELECT * FROM users ORDER BY id LIMIT 10;
Mahimmanci: ba tare da ORDER BY, database na iya dawo da sarurun cikin kowane tsari, don haka shafuka na iya hadewa ko kada sarurun. Kullun watsawa ta tsafin jeri na tsayi lokacin pagination.
⚠️ LIMIT 10 OFFSET 1000000 — the DB must SKIP a million rows first (slow on deep pages).
For large datasets, KEYSET (cursor) pagination is far more efficient:
WHERE id > :last_seen_id ORDER BY id LIMIT 10 -- uses an index, no skipping
ORDER BY da LIMIT abubuwa ne na asali don nuni da bayanai ta hanyar da ta dace, wanda ya bugi — watsawa sarurun da dawo da shafuka maimakon teburin gida abubu ne kusan cikakke (jerin da dukka, teburin, ko abin ciniki a aikace-aikace), don haka fahimtar su ɗauki ilimi da kullun. ORDER BY (watsawa ta jeri ɗaya ko fiye, tare da kariya) na dole ne don gabatar da bayanai cikin tsari na ma'ana, da LIMIT/OFFSET suna aiwatar da pagination (dawo da sarurun bayanai da yake iya gudana) — duka sannu-sannu a aikace-aikace.
Tubali gida gida masu mahimmanci ne: kullun amfani da ORDER BY lokacin pagination (ba tare da shi, tsari na sarurun ba a bayyana shi, haifar da shafuka da ba daidai ba waɗanda ke hadewa ko kada sarurun — cewa gaske, sashen kusan kusan), da fahimtar cewa OFFSET pagination yana rasa ido akan shafuka na zugu (database dole ne ya tsallake dukkan sarurun da suka gaba, yana jajere don babbar offsets), don haka keyset/cursor pagination (WHERE id > last_seen) ya fi jajartawa ga jerin datuwa masu girma — ilimin da ke da daraja. Tun da watsawa da pagination abubuwa ne da dole ne don kusan duk nuni na bayanai, da juz jurn cewa sharataccen tsaro (ORDER BY don tsayar tsayar pagination) da la'akari na aiki (OFFSET ga keyset ga datuwa masu girma) ta amfani ga daidaitawa da saurin, mastery ORDER BY da LIMIT — watsawa, offset pagination, tsarin tsayar-tsayar, da keyset zabin ga sikeli — aiki ne, ilimin da ake amfani da shi cikakke na gida don gina aikace-aikace waɗanda ke gabatar da bayanai ta kyau.