Re: Help: a difficult SQL request

Try something like this:

select time,volume from
(
select time,volume, lag(volume) over (order by time) prev_volume from t)
where volume = prev_volume
order by time; Received on Sun Feb 23 2003 - 20:19:49 CST