mas,
ini saya kirimkan dari arsip milis ini
semoga berguna
SELECT Count(*) as Serial_N, TableA.P_Name, TableA.Amount FROM TableA
INNER JOIN
(SELECT * FROM TableA) A ON
TableA.TablePrimaryKey>=A.TablePrimaryKey
GROUP BY TableA.P_Name, TableA.Amount
ORDER BY TableA.P_Name
----- Original Message -----
From: Ashok Hari
Dear Friend "Neil Berry"
First i thks to response.
My Question is totally different from wht u replay the answer.
"Serial No" is a Field does not exist in TABLE_NAME (Select * from
TABLE_NAME). It's a dynamic one.
For example "Serial No" is refelect the down value of Number of rows
affected in SQL Query output.
Ex1
Suppose SQL Query Output generate 3 rows then out put should
come following below
S_No P_Name Amount
1. ### ###
2. ### ###
3. ### ###
Ex2
Suppose SQL Query Output generate 5 rows then out put should
come following below
S_No P_Name Amount
1. ### ###
2. ### ###
3. ### ###
4. ### ###
5. ### ###
I hope know u get my point. If u know the result plz immdly replay me.
it's very urgent one.
Regards
H.Ashok
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
