Arsip: [tips] Perintah SQL -> LIMIT untuk MS SQL.
more 17 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))SELECT ProductID, ProductName FROM Products LIMIT 10, 10
more 17 years ago
ndenkltop
trims banget tipsnya. oprek-oprek lagi yaa... kirim tipsnya sering-sering :lol:
more 17 years ago
reminder2k1
Aku dah pernah nyoba script spt itu, cuma kesulitannya untuk nampilkan record dari 11-20 di MS SQLnya gimana mas???
more 17 years ago
cyber_hecker
walah.. udah jelas-jelas di tulis disitu kok masih nanya sih ??? mo ku sate juga nih anak... wakakakak... :D
more 17 years ago
reminder2k1
Sory mas... Baru tak cobain... & tenyata mueenntteeebbbb.....
Thx ya...
more 17 years ago
i_hasibuan
@walking_body
silahkan modifikasi sendiri code-nya kang CH,, sebelum di-sate juga..
hehehe
more ...
- Pages:
- 1
reply |
Report Obsolete
AI Forward
🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- Bikin EXE yang keciiilll ........
by xerion in Tip n Trik Pemrograman more 18 years ago - Mencari Form dengan DLL...?
by budi_bunga in Hal umum tentang Pascal Indonesia more 18 years ago - COMBOBOX baca SQL Gimana caranya..??
by D-Nai in MySQL more 18 years ago - ShellExecute vs WinExec!!!!
by diqshu in Tip n Trik Pemrograman more 18 years ago - find karakter in array
by viq_01 in Tip n Trik Pemrograman more 17 years ago - [Tanya] Copy drag & Drop Text Terseleksi ke Delphi...
by s0t4 in Tip n Trik Pemrograman more 13 years ago - Cara mengubah file *.wav to string?
by ekopewe in Multimedia & Graphic Enhancement more 16 years ago - Delphi .Net vs C#....kasi coment donk....!
by batozai in OOT more 17 years ago - Mengaktifkan enter pada pemrograman delphi
by em_bjr in Tip n Trik Pemrograman more 17 years ago - Ask : penggunaan keyboard untuk stringgrid
by venomz in Tip n Trik Pemrograman more 17 years ago