subject:"\[SQL\] Fastest way to get max tstamp"

Re: [SQL] Fastest way to get max tstamp

2006-08-28 Thread Richard Broersma Jr

> name | program | effective | tstamp | rate > --+-+++-- > jdoe | AAA | 2006-07-01 | 2006-07-16 23:42:13.809214 | 20 > jdoe | BBB | 2006-07-01 | 2006-07-16 23:42:13.809214 | 20 > jdoe | AAA | 2006-08-16

[SQL] Fastest way to get max tstamp

2006-08-28 Thread Henry Ortega

This is my table: name | program | effective | tstamp | rate --+-+++-- jdoe | AAA | 2006-07-01 | 2006-07-16 23:42:13.809214 | 20 jdoe | BBB | 2006-07-01 | 2006-07-16 23:42:13.809214 | 20 jdoe | AAA | 2006-