This is my table:<br /> name | program | effective | tstamp | rate <br
/>------+---------+------------+----------------------------+------<br/> jdoe | AAA | 2006-07-01 | 2006-07-16
23:42:13.809214| 20 <br /> jdoe | BBB | 2006-07-01 | 2006-07-16 23:42:13.809214 | 20<br /> jdoe | AAA |
2006-08-16| 2006-08-25 11:56:50.380575 | 20<br /> jdoe | BBB | 2006-08-16 | 2006-08-25 11:56:50.380575 | 20<br
/> jdoe| AAA | 2006-08-16 | 2006-08-25 11:57: 17.394854 | 20<br /> jdoe | BBB | 2006-08-16 | 2006-08-25
11:57:17.394854| 20<br /> jdoe | AAA | 2006-09-01 | 2006-08-28 12:38:42.486513 | 20<br /> jdoe | BBB |
2006-09-01| 2006-08-28 12:38:42.486513 | 20<br /><br /><span style="font-weight: bold;">I want to get:</span><br
/> name| program | effective | tstamp | rate <br
/>------+---------+------------+----------------------------+------<br/> jdoe | AAA | 2006-07-01 | 2006-07-16
23:42:13.809214 | 20<br /> jdoe | BBB | 2006-07-01 | 2006-07-16 23:42:13.809214 | 20<br /> jdoe | AAA |
2006-08-16| 2006-08-25 11:57:17.394854 | 20<br /> jdoe | BBB | 2006-08-16 | 2006-08-25 11:57:17.394854 | 20<br
/> jdoe | AAA | 2006-09-01 | 2006-08-28 12:38:42.486513 | 20<br /> jdoe | BBB | 2006-09-01 | 2006-08-28
12:38:42.486513| 20<br /><br />Basically, for effective='08-16-2006', it only gets the latest inserted<br />record
(usingtstamp) for that effective date, which is 2006-08-25 11:57: 17.394854.<br /><br />So what is the quickest way to
dothis?<br /><span style="font-weight: bold;">I can always do:</span><br />Select * from Table t where tstamp=(select
max(tstamp)from Table t2 where t2.name=t.name and t2.effective=t.effective )<br />but it takes so long since this is a
hugetable.<br /><br />Any suggestions?<br />
