Is there a way to select nth column in a SELECT clause from a table/view
Posted
by Vishal Seth
on Stack Overflow
See other posts from Stack Overflow
or by Vishal Seth
Published on 2010-05-04T20:20:17Z
Indexed on
2010/05/04
20:28 UTC
Read the original article
Hit count: 263
I've this GIGANTIC view with several hundred columns and I need to select 114th column something like:
SELECT "144" FROM MyView;
PS: Obviously, I don't know the name of the column. I just copied the results row into an Excel file, searched for a particular value that is in EJ column so I want to select all rows showing only nth column in my view to do my further debugging.
Cheers!
© Stack Overflow or respective owner