gt;
Sent: Saturday, November 17, 2001 3:25 AM
Subject: Re: Inserting Data on top
> Hello Sandeep!
>
> > I am trying to insert data from a form which has 4 fields such that the
data
> > always sits at the top in my database occupying locations :
> >
> > SEC_ID: 1, 2 , 3
INSERT always places data at the "end" of the table. SQL makes no assumptions
about the ordering of data. If you specify no order, you get "arrival
sequence", being the order the data was written to the table. If you want to
see the data in a certain order, you must order it with the ORDER BY clau
Hello Sandeep!
> I am trying to insert data from a form which has 4 fields such that the data
> always sits at the top in my database occupying locations :
>
> SEC_ID: 1, 2 , 3 & 4
>
> Everytime i insert data the data gets appended at the end i,e, if the first
> 4 fields are occupied my data tak
Hi all,
I am trying to insert data from a form which has 4 fields such that the data
always sits at the top in my database occupying locations :
SEC_ID: 1, 2 , 3 & 4
Everytime i insert data the data gets appended at the end i,e, if the first
4 fields are occupied my data takes the postions 5,6
