Top 10 Percent

[aftabn10]

I have written the following query that returns the top 10 items from a column. I am looking to change this to give me the top 10 Percentage from the same column but dont know how to change my query. Could somebody please help.

 

The following is my query:

 

SELECT "TEST AHT By Agent".RootirID saw_0, "TEST RE Values Dim"."Queue Name" 
saw_1, "TEST AHT By Agent"."Agent ID" saw_2, "TEST AHT By Agent"."AHT -OM" 
saw_3 FROM Genesys_TEST WHERE ("TEST RE Values Dim"."Queue Name" LIKE 'Queue 1
') AND (TOPN("TEST AHT By Agent"."AHT -OM", 10) <= 10) ORDER BY saw_0, 
saw_1, saw_2

 

Thanks in advance.

[Yesideez]

Top 10% of what exactly?

 

I might be very wrong but my first thoughts are to add a new field to your database and populate it with the percentages for each record then you can do a simple ORDER BY percentage DESC LIMIT 0,10 type query.

[aftabn10]

Thanks for your reply Yesideez. Currently within my query I have the following:

 

AND (TOPN("TEST AHT By Agent"."AHT -OM", 10) <= 10)

which gives me the top 10 values within the TEST AHT By Agent column.

 

What i would like is for it to give me the top 10% which would mean it gives me a total of 6 values as the total entries within the TEST AHT By Agent column is 56.

 

Hope that makes sense. Thanks once again.

[Yesideez]

Are you using SQL or MySQL?

 

I think maybe you're in the wrong forum and shold be here:

 

http://www.phpfreaks.com/forums/index.php/board,35.0.html

 

...I'm pretty sure TOPN is a MSSQL command.

[aftabn10]

Yesideez, currently I am using SQL.

[revraz]

SQL is a language, MSSQL, MySQL, Oracle are Database Applications.

[fenway]

Yesideez, currently I am using SQL.

SQL is a language, MSSQL, MySQL, Oracle are Database Applications.

That would explain the double-quotes in the other post...