Huehehehe... ini saya kasih... dulu saya yg nanya ke forum ini, trus ditunjukin ama mas heru rahadyan... Itu kalo mas darsana nanya syntax SQLnya...
Mudah2an bermanfaat... wassalam, Darmawan, MS D> SELECT Count(*) as Serial_N, TableA.P_Name, TableA.Amount FROM TableA D> INNER JOIN D> (SELECT * FROM TableA) A ON D> TableA.TablePrimaryKey>=A.TablePrimaryKey D> GROUP BY TableA.P_Name, TableA.Amount D> ORDER BY TableA.P_Name D> D> D> ----- Original Message ----- D> From: Ashok Hari D> D> D> Dear Friend "Neil Berry" D> First i thks to response. D> My Question is totally different from wht u replay the answer. D> "Serial No" is a Field does not exist in TABLE_NAME (Select * from D> TABLE_NAME). It's a dynamic one. D> For example "Serial No" is refelect the down value of Number of rows D> affected in SQL Query output. D> D> Ex1 D> Suppose SQL Query Output generate 3 rows then out put should D> come following below D> S_No P_Name Amount D> 1. ### ### D> 2. ### ### D> 3. ### ### D> D> D> Ex2 D> Suppose SQL Query Output generate 5 rows then out put should D> come following below D> S_No P_Name Amount D> 1. ### ### D> 2. ### ### D> 3. ### ### D> 4. ### ### D> 5. ### ### D> D> D> D> I hope know u get my point. If u know the result plz immdly replay me. D> it's very urgent one. D> D> Regards D> H.Ashok D> 1. Gimana cara memberikan nomor urut pada laporan di CR ? D> sepertinya sudah dibahas namun saya cari2 di inbox tidak ada, mhn D> bantuannya yg masih menyimpan utk mem-fwd ke japri. D> Salam, D> nyoman ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/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/
