I've got a large spreadsheet that I'm querying with Silk. There are too many parameters to bring the whole row back with the standard SELECT * FROM SQL query. I was wondering how to change the * to a range of colums (Say A to E for example)?
You need to know the names of the columns, I think (I only do database stuff, not spreadsheets).
Try something like:
SELECT A, B, C, D, E FROM tablename
(assuming the columns are called A, B, C, D, E)
Chris R Mead
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
Ah, I was making to hard by using : or -, all I needed was a ,