How to find Rank(return Top 3 Country)

Question

How to find Rank(return Top 3 Country)

Valued Member

Points: 65

June 29, 2004 at 11:51 pm

Hi All,These are the records  I've in my table. I need to return top 3 countries (rank) by Sales.Record          Date                Country                Sales1               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                Sales2                01.01.04            IN                       92%1                01.01.04            AU                       80%4                01.01.04            USA                      75%How to write query for that?ThanxRgdsK.Senthil Kumar

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Senthil Kumar-146857 Valued Member Points: 65 More actions · Answer 1

Hi All,

This is my questions. Pl. ignore the previous one.

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

Phil Parkin SSC Guru Points: 245813 More actions · Answer 2

Try something like this:

select top 3 record, date, country, sales

from (tablename)

order by sales desc

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.