0

I am trying to filter one data field for the top ten percent of values in that field. Something like:

SELECT TOP(10)PERCENT IN "TUNGSTEN"

However, my database through QGIS does not seem to support SELECT TOP and I am new to these expressions and may be way off.

This artile, https://www.w3schools.com/sql/sql_ref_top.asp, states that :

Note: Not all database systems support SELECT TOP. MySQL uses LIMIT, and Oracle uses ROWNUM.

I'm guessing I may have the wrong code for the database system but I can't make the other options work yet.

Can you give me some direction?

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
Anomalous Exploration
  • 117
  • 7
  • 1
    Does this help? https://gis.stackexchange.com/q/373508/88814 or rahter this one: https://gis.stackexchange.com/questions/384547/exporting-features-when-column-value-between-specific-percentiles – Babel Mar 17 '21 at 20:58
  • That looks helpful. I will look into it. Thanks! – Anomalous Exploration Mar 18 '21 at 18:41

0 Answers0