Home -> Usenet -> comp.databases.oracle -> Re: Get 10 latest customers

Re: Get 10 latest customers

From: David R. Thrash <thrash_at_delphi.onramp.net>
Date: 1995/05/12
Message-ID: <3p09h1$9pl_at_ns1.unicomp.net>#1/1 









This is database 101 - n'est pas?



Select Customer_Code


  from BOOKING b1


 where 10 <= (select count(*)

                from BOOKING b2
               where b2.Transaction_date > b1.Transaction_date)


/


--
David R. Thrash
dthrash_at_tac-one.com             Compuserve:  76217,1304
http://www.tac-one.com/

Thrash & Company
9102 Garland Road, Suite 216I


Received on Fri May 12 1995 - 00:00:00 CEST












Original text of this message