No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
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 … |
|
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 … |
|
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 … |
|
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 … |