A question that was asked among a few developers, now deferred to DBA experts:
Is there a way to select multiple columns within a table instead of
SELECT'ing columns piecemeal? For example, let's say example table contains 26 columns respectively titled by letters (e.g. A, B, C, etc.). Suppose I would like to retrieve all rows from columns H, I, J, K, L, M, N, O, P- is there a more efficient way to begin the
SELECT statement of the following query?
SELECT H, I, J, K, L, M, N, O, P FROM table;
Perhaps something like so?
SELECT H-P FROM table;