Re: How to get the first four rows???
From: Srinivas Ramgopal Tanikella <eetani_at_unix1.sncc.lsu.edu>
Date: 1996/05/24
Message-ID: <Pine.A32.3.91.960524144826.50816B-100000-100000-100000-100000_at_unix1.sncc.lsu.edu>#1/1
Date: 1996/05/24
Message-ID: <Pine.A32.3.91.960524144826.50816B-100000-100000-100000-100000_at_unix1.sncc.lsu.edu>#1/1
On Wed, 22 May 1996, Wilfred Ng wrote:
>
>
> I think the solution suggested by Muhammad would have some problems if more
> than one row having the same x_date value. For example if the minimum x_date
> occurs more than 4 times, then you will never ever get this x_date because the
> count(*) is greater than 4.
>
> Cheers,
> Wilfred.
> UCL, London.
>
>
>
>
Muhammad A. Malik's solution worked when I tried this out As for the two or more dates having equal dates, since my orderdate was from sysdate which had time in it as well. It was ok.
Andal Nalina
Consultant
Deloitte & Touche Consulting Group
DRT Systems International L.P,
Received on Fri May 24 1996 - 00:00:00 CEST