[This topic is migrated from our old forums. The original author name has been removed]
in AQT, there is a button to select distinct values of a column in data tab. People use it a lot.
in DBVis, we could a sub-menu item in SQL to Editor to do so if adding a button is not desired. The generated SQL should concern only the columns selected by users such as 'select distinct column1, column2 from tableA'.
Regarding 'SQL to Editor', is it possible to allow end users to customize the menu items to add their own SQL such as 'select max(col), min(col) from tableA'. That will be very helpful and open up endless possibilities.
Then later when customization of toolbar (icon/button) is added, users will have their one-click button for 'select distinct' and much more!
anonymous