| date problem [message #23095] |
Mon, 18 November 2002 06:34  |
jasn
Messages: 39
Registered: October 2002
|
Member |
|
|
I have a table like
id sal_month
1234 0102
1234 0202
1234 0302
4567 0102
4567 0202 etc
now want to get the latest against an id
help me
thanx in advance
|
|
|
|
| Re: date problem [message #23097 is a reply to message #23095] |
Mon, 18 November 2002 07:31  |
Ar.
Messages: 3
Registered: November 2002
|
Junior Member |
|
|
Hi Jan,
Try this..
Assumption sal_month is varchar field.
select id, to_char(max(to_date(sal_month,'mmyy')),'mmyy') from table1
group by id
HTH.
Ar.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
