Select values over multiple rows in one column in a SQL Result Set
I would like to be able to select multiple values in a column in the result set from a sql query. Today all cells "between" the first and the last value are also selected.
If there are 5 rows of data with multiple columns in the result set. Then from column Id I would like to select values from row 2 to row 4, then only those 3 values in that column should be selected.
If there are 5 rows of data with multiple columns in the result set. Then from column Id I would like to select values from row 2 to row 4, then only those 3 values in that column should be selected.
Comments
Went into Preferences -> Results -> Results to data grids and chose Datagrid Mode, which I noticed that the result window did not change to Datagrid Mode in current query windows but only works for a new query window made after the change has been made.
BR