According to the statement can now get all the column name in the list, but I just want to get a 30-33 between the column should be how to write?

CodePudding user response:

Through the row_number number is ok,

CodePudding user response:

https://dba.stackexchange.com/questions/14791/how-to-identify-columns-order-in-a-table

CodePudding user response:

reference 1st floor is nu month god reply:

by row_number number is ok,

Row_number is sort is not a place in the table

CodePudding user response:

reference qq_30335331 reply: 3/f

Quote: refer to 1st floor is nu month god reply:

by row_number number is ok,

Row_number is sorting is not in the position in the table

Don't say it's position in the table, I said is number,
So long as has the number, how to take the field casually,

I think whoever made excessive row_number page, should not think I said is the position in the table,

CodePudding user response:

reference qq_30335331 reply: 3/f

Quote: refer to 1st floor is nu month god reply:

by row_number number is ok,

Row_number is sorting is not in the position in the table

Results view has line Numbers, but cannot be used to judge, row_number can add a column can be used to judge the line number, and then can be selected,

CodePudding user response:

Under that excuse me what method can complete this request? Please point explain in more detail

CodePudding user response:

System at a stored procedure, also can get the table structure