GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL

 Print  |  
Question:  Select from table without using column name

Answer: 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


March 03, 2009 00:35:31 #10
 ghoshamit83   Member Since: March 2009    Total Comments: 1 

RE: Select from table without using column name
 
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.
     

 

Back To Question