coba perintah ini deh:
SELECT TOP 10 * FROM [namatabel] ORDER BY NILAI DESC
smoga mbantu
Brgds,
Lim Agus Fitrian
| "skdmdn" <[EMAIL PROTECTED]>
Sent by: [email protected] 02/01/2006 11:43
|
|
Teman2,
Misal saya punya tabel data:
NAMA NILAI
AAA 7
BBB 10
CCC 8
DDD 6
EEE 5
FFF 7
GGG 9
HHH 6
IIII 8
JJJ 4
KKK 3
LLL 7,5
MMM 8,1
NNN 9,9
Bagaimana perintah sqlnya untuk menampilkan nilai2 10 besar tertinggi?
Thank's B4
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB"
on the web.
- To unsubscribe from this group, send an email
to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
