Click here to Skip to main content
15,898,374 members

Comments by sammsul (Top 12 by date)

sammsul 13-Jun-13 4:53am View    
thanks for feedback but itz not correct way what i want....i just solve the problem and sln in below................

SELECT PRT.CID, PRC1.AmountDeposit, PRC1.Ddate FROM Deposit PRT LEFT OUTER JOIN Deposit PRC1 ON PRC1.CID = PRT.CID LEFT OUTER JOIN Deposit PRC2 ON PRC2.CID = PRC1.CID AND PRC2.Ddate > PRC1.Ddate WHERE PRC2.CID ='C0000000000300'
sammsul 11-Jun-13 5:11am View    
BUT I WANNA ALL max Date whats in my query.........so, what can i do ...you write for one max date for ...select max(LoanDate)
from ..... but i want max date all of date in my query..........
sammsul 10-Apr-13 8:00am View    
if you need sln then mail me ::: info@augusttechbd.net23.net .........thanks
sammsul 4-Apr-13 7:53am View    
Anyway, i just solved my problem....Thanks every one...
sammsul 19-Mar-13 4:50am View    
i do but i got the same problem....