I want to select distinct values from a table column but i am not able to write the SQl command in kexi , I am using mysql sconnection

venky80 wrote:I want to select distinct values from a table column but i am not able to write the SQl command in kexi , I am using mysql sconnection

Hi venky80. Please file a wish to bugs.kde.org. We will add this feature to Kexi Queries in 2.5. You can do the same with other similar SQL features.

By the way: I think it's worth to note in this context again:

Kexi is not a database front-end and is not planned to become one

By database front-end I mean a tool that knows specific of database back-end (like MySQL) and offers access to most or all the features.

Technical note: It's enough to know that Kexi does not take user's SQL statement intact; it won't send that string to the back-end. Instead Kexi parses the string to know everything about the statement. This gives security, higher back-end-neutrality and control but also future extensibility, since the SQL dialect is what we call KEXISQL. All this happens at the cost of poor feature set.

To improve SQL feature coverage we need contributors that would enumerate all SQL features, maybe also per back-end, and prioritize them. Another easy way to start contributing!

For similar topic, see Question 2.5 at http://kexi-project.org/wiki/wikiview/i ... xiFAQ.html.

Optional solution is to let the user decide and to allow native queries. Pros and cons are now documented in this wish: https://bugs.kde.org/show_bug.cgi?id=298149