In a database, the order of the columns in the table is TOTALLY irrelevant. The same is true for the order of the rows. This is an important basic concept in relational databases.
In other words it just doesn't matter at all, you write your query and STATE the columns you wish to be working with, in whatever order suits yours query.
eg table people with columns address, firstName id, town, surname, age, postcode/zipcode can be queried in any order you choose, such as
select id, surname, firstName, address, town postcode/zipcode from people.
select age, firstName, surname, town from people.
Hi, According to me you want output like that form table
"SELECT id,name,sname FROM Table_name";
But I have doubt in mention query, then please mention your query in proper way,Only then I'll Help you, with efficient way.