How to get a particular column [message #337771] |
Fri, 01 August 2008 02:30  |
koteshwar
Messages: 7 Registered: October 2006 Location: hyderabad
|
Junior Member |
|
|
Hi ,
I have got a table having 30 columns as
sale_id,
Customer_id,
Cust_address,
-
-
-
-
-
-
-
-
- etc,
my criteria is to retrieve the column 5 and 20.I don't know the column names in that table.This should be done using an sql statement.
|
|
|
|
|
|
|
Re: How to get a particular column [message #337812 is a reply to message #337787] |
Fri, 01 August 2008 04:54   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Michel Cadot wrote on Fri, 01 August 2008 10:35 |
And what is the business need to this?
|
pablolee wrote on Fri, 01 August 2008 09:57 | What have you tried?
|
koteshwar wrote on Fri, 01 August 2008 10:57 | Thanks a lot for the help.
|
Whatever you do, ignore those questions.
Just imagine, people might actually give you good advise..
|
|
|
Re: How to get a particular column [message #337883 is a reply to message #337771] |
Fri, 01 August 2008 08:17   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
koteshwar wrote on Fri, 01 August 2008 03:30 |
I have got a table having 30 columns as
sale_id,
Customer_id,
Cust_address,
-
-
-
-
-
-
-
-
- etc,
my criteria is to retrieve the column 5 and 20.I don't know the column names in that table.This should be done using an sql statement.
|
Sounds like another person enrolled in the Monty Python School Of Nonsensical Requirements. A lot of people here seem to be in the same class.
|
|
|
|
|