If you are using Oracle 8.i or greater, you can do: select * from yourTable where rownum < 2
JW --- Robbie Staufer <[EMAIL PROTECTED]> wrote: > Hi, > > Is there a way to refer to the first row of a database (row 0?) ? > > For example, the first row of my database contains header information. > I want the header row to print out first whenever data is requested, so > the output file looks like this: > > header, header, header, header, header > data, data, data, data, data, > data, data, data, date, data > > I know how to print out the data, but can't figure out how to ask for > the first row. > > Many thanks, > Robbie > > -- > -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > Robbie Staufer > NCAR/SCD > 1850 Table Mesa Dr. Rm. 42 > Boulder, CO. 80305 > (303) 497-1836 > > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
