Loading ...Strangely enough, select *,colname from tbname; works just fine, whereas select colname,* from tbname; fails! So if you would like to see all columns, but have one or more of them displayed to the left of the set, you have only one way left to do it ‘comfortably’:
select colname,tbname.* from tbname; well two really but this is really the same
select colname,tb.* from tbname tb;
Because Sharing is Caring
as a DBA, I have to say, any select that has a ‘*’ in it is bad. I might use select * when I am running ad-hoc queries, but would never recommend it in production in any fashion. Name the columns.
Agreed Raj, select * from table is NOT good (bad performance, memory issues, caching issues etc), one should know what they need and select specific columns. This case was simply a developer debugging some sql on qadev and wanted to see the bigger picture, yet starting the result set with a particular column.