Sometimes, developers prefer to specify a list of columns in a select statement. SQL Edge® provides a wizard to simplify the task. Just double-click any table, view, or synonym node in the “Database Explorer” will display the “Create Selection Query” wizard:
Choose the desired columns in the first page, and enter a query condition in the second page:
Click the “Finish” button to insert the query into the SQL editor:
You can make more modifications of the query, and then execute it.