how to get only those which have maximum value in a specified column in
asp.net c#
I have a table with "customer_id, date, installment_no, amount" columns. I
want to get the information of last installment of each customer_id till
today. here installment_no is int type and when a new installment is
deposited, the installment_no is increased by 1 in new entry. My table
look like:
CS1001 | 12-06-2013 | 1 | 2500
CS1002 | 19-06-2013 | 1 | 1600
CS1001 | 14-07-2013 | 2 | 2500
I want to get a sqlcommand statement for do so.
No comments:
Post a Comment