I have a LOG
table with LOG_ID, TIME and TEKST columns
I want to get
records for the last hour (or certain time) (x records) and if less then N
records in last hour, then get also last N-x records so that I get N
records alltogether. And I wnat them ordered descening (last record
first)
I tried with
embedded select with ROWNUM and COUNT and so on but failed to get right records,
because you can not order in embeded SELECT.
Please
help
Rok