+ Start a Discussion

Nulls Last in Picklist field

I am not able to use 'NULLS LAST' while sorting the data by a picklist field.

I am using SOQL of the form

Opportunity[] op=[select <picklist field> from opportunity where name!=null order by <picklist field> NULLS LAST];

but the SOQL doesnot produce a result where nulls be placed at last.

Please suggest a resoultion to the issue.

Daniel Ballinger
See the idea Implement SOQL Order By <Picklist Field> NULLS LAST

Need an account? Sign Up

Have an account? Sign In