How can we retrieve the data from a table

rameshbabu · New User Joined: 23 May 2005 Posts: 27

Hi
plse clarify my doubt

I want retrieve the first ten columns with out knowing their name(columns)
from a table(table name X)

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi Ramesh babu,

Its not possible to retrive first N columns from a database table.

Gops · New User Joined: 21 Jul 2005 Posts: 23

Hi Guys,

Try out these queries.

select * from TABLENAME fetch first row only;

select * from TABLENAME fetch first 50 rows only; ==> will fetch first 50 rows from the table.

Cheers

Gops

paru · New User Joined: 24 Jun 2005 Posts: 9 Location: INDIA

The queries suggested would only fetch select rows and not select colomns.i.e, in the example stated the 50 rows would contain all the colomns.So i think its not possible to select certain colomns alone from any table.

Cheers,
Paru

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

Try out these queries.

select * from TABLENAME fetch first N only; where n= no of rows u want2 fetch