Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Where are you wanting to do this? In the script or front end? Can you elaborate a little?
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.
On what basis you want to find the 8 max Id's?
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.
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