Re: Get 10 latest customers

In article <3oqqp4$6as$1_at_mhadf.production.compuserve.com>, Frank Greene <74200.427_at_CompuServe.COM> writes:

|> Try


|> 	select * from booking


|> 	where rownum <= 10

|> 	order by transaction_date;


This does not work Frank.

You got to do the following,

1. create a view

	Create view my_booking as
		select transaction_date,.......
		FROM   booking
		group by transaction_date,......;

	This view orders the output by transaction date

2) select from the view

	select transaction_date,..... from my_booking
	group by transaction_date,.....
	having rownum > (select count(*)-10 from my_booking);

	This gives the latest 10 customers by transaction date.

Madhavi LOkam
Consultant
Ford Motor Comapany Received on Thu May 11 1995 - 00:00:00 CEST