Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~3K People Reached
Member Avatar for kutta_vin

Hello friends, I am new to this site, this is my first post, My question is.. How to calculate the one rows value for next row value? [code=sql]select @rownum:=@rownum+1 "sl.no", b.bus_activity_desc "Type",r.trn_no, o.Office_name,o.Address,o.Address2,o.Address3, DATE_FORMAT(r.trn_date,GET_FORMAT(DATE,'EUR')) as trn_date, l.Account_id , if(r.trn_type=6,r.total_trn_value,0) "Credit", if(r.trn_type=7,r.total_trn_value,0) "Debit", if(r.trn_type=6 ,@cbal:=(r.total_trn_value+@cbal),@cbal:=(@cbal-r.total_trn_value)) "Closing Balance" from(select @rownum:=0) s, office_master …

Member Avatar for Mukoro
0
2K
Member Avatar for kutta_vin

Hi all, I am vinodh, my system configurations are as follows. Intel D845GVSR chipset Pentium 4 prcessor with 2.4G.Hz speed 2 rams i.e 1gb ddr and 256mb ddr. total is 1.25 gb one samsung cd writer and Lg DVD writer. 160gb seegate and 40gb samsung harddisks In the above given …

Member Avatar for JackCollins
0
213
Member Avatar for kutta_vin

Hi friends, I think the MySql is not case sensitive for selecting values. for example I am having a table called dept, Id | Depart 1 | BTECH 11 | it 12 | ibt 2 | BE 21 | cse 22 | ece Now i want to select the capital …

Member Avatar for kutta_vin
0
151
Member Avatar for MiDude

There is a pop-up continually appearing on my Laptop from the taskbar that states that my computer is infected with virus and it may cause critical system failure. :mad:. I downloaded Ewido and TrojanHunter and ran sweeps...however the popup still appears on the screen. My laptop is running relatively slow …

Member Avatar for kylethedarkn
0
240