Z
zmsaadeh
I have table with many recodrs as this table:
customerID Date Stock1 Stock2 Stock3 Stock4
112105222 22/01/2006 5 6 2 1
112105222 23/05/2006 4 8 6 7
112105222 01/02/2007 6 9 4 6
112101024 12/12/2007 7 8 9 1
112101024 15/02/2007 7 9 2 1
. .
. .
. .
by select qury I want show just the last record for each customerID as this
table
customerID Date Stock1 Stock2 Stock3 Stock4
112105222 01/02/2007 6 9 4 6
112101024 15/02/2007 7 9 2 1
Plz who is can help me in select qury
thanx
customerID Date Stock1 Stock2 Stock3 Stock4
112105222 22/01/2006 5 6 2 1
112105222 23/05/2006 4 8 6 7
112105222 01/02/2007 6 9 4 6
112101024 12/12/2007 7 8 9 1
112101024 15/02/2007 7 9 2 1
. .
. .
. .
by select qury I want show just the last record for each customerID as this
table
customerID Date Stock1 Stock2 Stock3 Stock4
112105222 01/02/2007 6 9 4 6
112101024 15/02/2007 7 9 2 1
Plz who is can help me in select qury
thanx