Query CSV file using Distinct & Order by

[T2102]

I need to query a csv file with C++ .NET and get a distinct list which is ordered by multiple criterion. If I write regular SQL, then i get the error "order by clause conflicts with distinct". If I use the prefix "SELECT * FROM ( SELECT" and suffix ")", then the order is lost. Is there a simple workaround using SQL or do I need to write my own code to get the distinct list?

[Lost User]

This appears to be nothing to do with .NET, try the Database forum.

MVP 2010 - are they mad?

[T2102]

I am using System::Data::OleDb::OleDbConnection. I know SQL; the problem is that some SQL code does not work fully with some .NET providers. I will try the database forum.