Need Help in Query ?

Ajit More

7y1.2k

Hi Friends,

following are the ex:-

1) I have a Table with 15 Column.

like (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)

i want a select query with column position change like

10,1,2,3,4,5,6,7,8,9,11,12,13,14,15

and i dont want to use each column name to use in query

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Hi.
That's not possible.You need to use column names. You can do by using dynamic Sql.
You can follow this article for more,
https://stackoverflow.com/questions/368505/is-it-possible-to-select-sql-server-data-using-column-ordinal-position
Thanks.
0
Sourav Mukherjee7y ago
This is not a valid expectation. First of all, such orientation of column if does not follow any rythm will not be possible to do with logic rather it will be a merge hard coding to the sequence you are looking for displaying your results.

secondly, w/o displaying column name you can't run your select statement, that is the structue of select query. If you want all columns to display you can use * instead.
0
Thiyagarajan E7y ago
Hi Ajit,

In your scenario, you can use a dynamic query to generate the select query. While generating the query string you can change the column order dynamically.

Thanks,
0
Vinay Kumar Dara7y ago
You cannot. The column order is just a "cosmetic" thing we humans care about - to SQL Server, it's almost always absolutely irrelevant.

What SQL Server Management Studio does in the background when you change column order there is recreating the table from scratch with a new CREATE TABLE command, copying over the data from the old table, and then dropping it.

There is no SQL command to define the column ordering.
0
Madan Shekar7y ago
try with this

set @row_num = 0; SELECT id,name,rating, @row_num := @row_num + 1 as row_index FROM users ORDER BY rating desc;
0
Sreekanth Reddy7y ago
Hi Ajit,

In sql server, defeinitely we need to provide column names for displaying the columns in order.
It is not possible without column names.
Thank you.
If understood & helps, Accept the answer.

0