Select Max - 1

[Emerson Placido 0]

Boa Tarde

 

Gostaria de realizar um select max - 1 ex:

 

 

select max (to_char(a.dt_operacao,'DD/MM/RRRR HH24:MI'))-1 from tb_log a where a.cd_sistema='1' and a.cd_objeto='23' and a.cd_usuario='1'

[Motta 645]

SELECT MAX(DATA_LENGTH)
FROM USER_TAB_COLUMNS
WHERE DATA_LENGTH <
(SELECT MAX(DATA_LENGTH)
 FROM USER_TAB_COLUMNS)

Isto ?!