Arsip: [tips] Perintah SQL -> LIMIT untuk MS SQL.
more 16 years ago
cyber_hecker
ini mungkin diriku yang rada bego.. dari dulu ngoprek-ngoprek MS SQL tapi baru tau cara mbikin syntax SQL sejenis 'LIMIT n, n' buat MS SQL agar bisa kayak mySQL.
ceritanya diriku pengen menampilkan hanya 10 record dari data no 10 - 20, biasanya sih gak bisa.. tapi habis semedi dan mandi kembang.. akhirnya muncul lah model query :
SELECT TOP 10 ProductID, ProductName
FROM Products
WHERE (ProductID NOT IN
(SELECT TOP 10 ProductID
FROM Products
ORDER BY ProductID ASC))
maksudnya : menampilkan 10 record dari tabel Product, dari no 11 - 20.
dalam mySQL cukup di tulis :
SELECT ProductID, ProductName FROM Products LIMIT 10, 10
note : khusus untuk yang lom tau.. yang udah tau ya maap :P
more 16 years ago
ndenkltop
trims banget tipsnya. oprek-oprek lagi yaa... kirim tipsnya sering-sering :lol:
more 16 years ago
reminder2k1
Aku dah pernah nyoba script spt itu, cuma kesulitannya untuk nampilkan record dari 11-20 di MS SQLnya gimana mas???
more 16 years ago
cyber_hecker
walah.. udah jelas-jelas di tulis disitu kok masih nanya sih ??? mo ku sate juga nih anak... wakakakak... :D
more 16 years ago
reminder2k1
Sory mas... Baru tak cobain... & tenyata mueenntteeebbbb.....
Thx ya...
more 16 years ago
i_hasibuan
@walking_body
silahkan modifikasi sendiri code-nya kang CH,, sebelum di-sate juga..
hehehe
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 3 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 4 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 11 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 11 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 11 years ago
Random Topic
- Koneksi ADOQuery Ke Syntax SQL
by saysansay in Tip n Trik Pemrograman more 18 years ago - [help] menampilkan data lookup yg dipilih dr listbox ke....
by binyo in Lain-lain more 11 years ago - Caranya bikin program monitoring PLC secara serial
by doni_vika in Network, Files, I/O & System more 13 years ago - Scanner
by clark in Hal umum tentang Pascal Indonesia more 17 years ago - adoQuery.Locate
by anosolano in Hal umum tentang Pascal Indonesia more 17 years ago - ambil tipe file
by weiy in Hal umum tentang Pascal Indonesia more 16 years ago - ada yang punya decopiler buat delphi??
by alvonz in OOT more 14 years ago - TMemoryStream
by muktaf in Tip n Trik Pemrograman more 16 years ago - Gimana caranya distribusiin aplikasi delphi pakai database ?
by putu_niki in Tip n Trik Pemrograman more 16 years ago - Store
by armanefendi in MySQL more 17 years ago