Seleccionar el registro ocurrido el último
Publicado por Decopas (7 intervenciones) el 27/02/2007 10:21:12
hola..tengo una tabla que tiene una columna de hora, y me gustaría únicamente seleccionar la que ha ocurrido la última.
Este es el contenido:
Source TimeLast DateLast Severity ProbableCause
---------- ----------------- -------------- ----------- ----------------------
5HCW 13:07:23.000 2/21/2007 !MINOR User Input 8;
5HCW 13:12:05.000 2/21/2007 !MINOR User Input 8;
5HCW 13:22:52.000 2/21/2007 !MINOR User Input 8;
5HCW 16:26:07.000 2/21/2007 !MINOR User Input 8;
Y esta es la consulta que tengo hasta el momento:
SELECT DISTINCT Source AS TermId, TimeLast AS TIME, DateLast AS DATE, Severity AS Severity, ProbableCause AS ProbableCause
FROM ALARMS
WHERE (AoType = 'SAU') AND
(Severity = '!CRIT.' OR
Severity = '!MAJOR' OR
Severity = '!MINOR' OR
Severity = 'WARN.') AND
(Subnetwork <> ' SUB0002SUB0001 ') AND ProbableCause like 'U%'
Alguna idea?..muchas gracias
Este es el contenido:
Source TimeLast DateLast Severity ProbableCause
---------- ----------------- -------------- ----------- ----------------------
5HCW 13:07:23.000 2/21/2007 !MINOR User Input 8;
5HCW 13:12:05.000 2/21/2007 !MINOR User Input 8;
5HCW 13:22:52.000 2/21/2007 !MINOR User Input 8;
5HCW 16:26:07.000 2/21/2007 !MINOR User Input 8;
Y esta es la consulta que tengo hasta el momento:
SELECT DISTINCT Source AS TermId, TimeLast AS TIME, DateLast AS DATE, Severity AS Severity, ProbableCause AS ProbableCause
FROM ALARMS
WHERE (AoType = 'SAU') AND
(Severity = '!CRIT.' OR
Severity = '!MAJOR' OR
Severity = '!MINOR' OR
Severity = 'WARN.') AND
(Subnetwork <> ' SUB0002SUB0001 ') AND ProbableCause like 'U%'
Alguna idea?..muchas gracias
Valora esta pregunta
0