Choosing max 8 campaign_id for Particular batch

[berryandcherry6]

Hi all,

Here i am having two columns,one is campaign_id and batch_meta_data_id.I want to get max 8 id's for particular batch id.

How could i acheive this please help me.

[sunny_talwar]

Where are you wanting to do this? In the script or front end? Can you elaborate a little?

[berryandcherry6]

In front end.

I am trying to do this because i want to find current campaign and previous campaign for a particular client.Each client will be having batches.So for each batch i am choosing max of campaign_id in expression.

[Kushal_Chawda]

On what basis you want to find the 8 max Id's?

[berryandcherry6]

For every particular batch id ,i want to find 1st max value,2nd max value,3rd max value .....,8th max value of campaign id.

ex if there is batch_id = 34,35

campaign_id  batch_id

     1                34

      2               34

     3                34

     4                35

      5                36

      6                 36

      7                 36

       8                36

       9               34

      10                35

      11                 35

       12                35

        13               35

         14               35

here i want to get campaign_id as 12,13,14 for batch_id 35,campaign_id as 9,3,2 for batch_id 34 if i am choosing max 3 values in campaign_id column.

[berryandcherry6]

Hi,

Thanks for reply

However,in load script or front end ,i want to get datas.

I am trying to do this because i want to find current campaign and previous campaign for a particular client.Each client will be having batches.So for each batch i am choosing max of campaign_id in expression.

Please help me in this regard