3 Lowest integer of a structure

Hello,

I have a struct:

32       3.33333333333
38       25
46       30
56       6.06060606061

The first col is the id and the 2nd col is percent.

I want to get the 3 lowest percent from the struct.

This topic has been closed for replies.

Correct answer Steve Sommers

I would attack this problem from the query side. Run another query like this:

select top 3 [id], [hourly_counter] ,[leads_per_day], [hourly_counter]/[leads_per_day]*100.00 as [pcnt] from [sales]
order by [pcnt] desc

</cfquery>

This was written and tested using MS-SQL. You may have to make adjustments if you are using something else.

Inspiring

Where did the structure come from?

Participant

It is coming from a loop.

I did

Steve SommersCorrect answer

Legend

I would attack this problem from the query side. Run another query like this:

select top 3 [id], [hourly_counter] ,[leads_per_day], [hourly_counter]/[leads_per_day]*100.00 as [pcnt] from [sales]
order by [pcnt] desc

</cfquery>

This was written and tested using MS-SQL. You may have to make adjustments if you are using something else.

Sign up