|
View previous topic :: View next topic
|
| Author |
Message |
cooldude
New User
Joined: 08 May 2008
Posts: 5
Location: pune
|
|
|
|
Hi,
Can anybody have idea for the below scenario.
I have to fetch the records from table having the latest date.
suppose for the cust_id E000101020 i have 20 rows and out of which i want the cust id having the latest date
i have tried a lot but not coming exactly what i expected. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Then please tell us what you have already tried so that we do not waste time suggesting the same thing.
Have you googled MAX |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| suppose for the cust_id E000101020 i have 20 rows and out of which i want the cust id having the latest date |
Would not the cust_id be E000101020 
| Quote: |
| Have you googled MAX |
Or searched this DB2 part of the forum (forum SEARCH above in the blue bar). |
|
| Back to top |
|
|
|
|
