Need Help in Query ?

Question

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

Salman Beg · Answer

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.

Sourav Mukherjee · Answer

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.

Thiyagarajan E · Answer

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,

Vinay Kumar Dara · Answer

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.

Madan Shekar · Answer

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;

Sreekanth Reddy · Answer

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.