How can I select column values from a table without knowing the column name ? Suppose , select employee_id from employees , now I don't know the column name and I want to select the column. Please let me know the answer
I have been using this sql query for selecting the column names of a table. select column_name from information_schema.columns where table_name 'tablename'
We can select from table without using column name. We can select form table according to sequence of column but only sequentially we can do this thing.
For ex: Select 1 2 from table; This query will give the result of those column which are in this sequence.