MVSFORUMS.com

ravikumar_sri2001

Hi Gurus,

I have a table called "my_table" with primary key defined on it.

If i do "SELECT * from my_table", will the result table in the order of primary key ?.

Thanks,
Ravikumar.

dbzTHEdinosauer · Posted: Mon Mar 12, 2007 8:13 am Post subject:

no, there is no default sequencing. If you want your returned rows in a particular sort order, you must have an ORDER BY clause.
_________________
Dick Brenholtz
American living in Varel, Germany

ravikumar_sri2001 · Posted: Mon Mar 12, 2007 11:02 pm Post subject:

Thank you very much Dick Brenholtz.

-Ravikumar.