pake fungsi MAX di sql
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "Joko Nurjadi"
<[EMAIL PROTECTED]>
Sent by: [email protected] 10/09/2005 10:03 AM
|
|
apa ada kemungkinan cara lain pake query sql? soalnya ini saya pasang di store procedure yg maunya ngembaliin satu record terakhir itu aja.
ada sih saya baca function LAST(column), cuman sayangnya nggak disupport di SQL Server 2000 yg saya gunakan.
Thx.
----- Original Message -----
From: ekoYahoo
To: [email protected]
Sent: Saturday, September 10, 2005 9:46 AM
Subject: Re: [Programmer-VB] query record terakhir
abis di select
recordset nya di movelast mas, gitu aja
----- Original Message -----
From: Joko Nurjadi
To: [email protected]
Sent: Saturday, September 10, 2005 9:14 AM
Subject: [Programmer-VB] query record terakhir
teman2,
sebagai contoh, saya punya table saham begini:
saham tanggal
--------- ----------
3 20050909
4 20050909
3 20050909
1 20050909
2 20050909
3 20050909
melalui perintah sql, saya ingin mengambil record terakhir, bagaimana caranya ya?
saya sudah mencoba pakai perintah:
select TOP 1 saham from saham order by tanggal desc
tetapi hasilnya 4, seharusnya kan record terakhirnya 3, asumsi kasus ini, nggak dimungkinkan menambah field pada table, misalnya dengan field autonumber atau logdate yg menyimpan getdate()
Thks buat bantuannya.
jn
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.20/95 - Release Date: 09/09/2005
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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.
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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.
