SQL

Posted in 2000

Norma Garcia Montoya — Fri, 12 May 2000 13:59:36 -0500 — source: Informix-list mailing list archive (1991-1998)

Dear recipient: I have a table with next information : clave fecha hora valor L01 05/01/2000 00:17:33.1 67 L01 05/01/2000 00:47:36.99 56 L01 05/01/2000 00:55:35.23 45 For each clave there are 3 mediciones (hora). I need to select only a registry where hora is menor. The number mediciones is variable. How to select this using SQL? Thanks for your atentions.