Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to do this in SQL?

How to do this in SQL?

From: Eric Dantie <edantie_at_rcanaria.es>
Date: 20 Aug 1999 13:56:45 GMT
Message-ID: <8E288DDD1edantiercanariaes@news.rcanaria.es>


I've got a table history(login varchar2(30), d date)

Each time someone connect to me, I do a insert into history(loginvalue, sysdate);

I need the 10 lasts connections for the login 'toto'.

How can I do this?

Thanks in advance.

Eric Received on Fri Aug 20 1999 - 08:56:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US