> Hi All,
>
> These are the records I've in my table. I need to return top 3 countries
(rank) by Sales.
>
> Record Date Country Sales
> 1 01.01.04 AU 80%
> 2 01.01.04 IN 92%
> 3 01.01.04 CH 50%
> 4 01.01.04 USA 75%
> 5 01.01.04 SG 25%
>
>
> The result set should be:
>
> Record Date Country Sales
> 2 01.01.04 IN 92%
> 1 01.01.04 AU 80%
> 4 01.01.04 USA 75%
>
> How to write query for that?
>
> Thanx
> Rgds
> K.Senthil Kumar