Posted by Oonz on 05/29/07 16:24

On May 29, 9:19 pm, Jason Lepack <jlep...@gmail.com> wrote:
> Tables don't store data in a logical order. They store data in a
> physical order. If you want to see data in an ordered fashion then
> create a view to do that. Also, Name is a reserved word, don't use
> it...
>
> SELECT
> No,
> NameField,
> Phone
> FROM
> yourTable
> ORDER BY
> No, NameField, Phone
>
> Cheers,
> Jason Lepack
> On May 29, 12:04 pm, Oonz <arund...@gmail.com> wrote:
>
>
>
> > Hi Friends,
>
> > How can we insert records in sorted order
>
> > like consider a table
>
> > No Name Phone
> > 1 test1 12345
> > 1 test1 23455
> > 2 test2 68638
> > 3 test3 67684
> > 4 test4 54808
> > 4 test4 74594
>
> > if i add a new record like this
>
> > 2 test2 34454
>
> > it should go in specific order. so that the final table should look
> > something like this
>
> > No Name Phone
> > 1 test1 12345
> > 1 test1 23455
> > 2 test2 34454
> > 2 test2 68638
> > 3 test3 67684
> > 4 test4 54808
> > 4 test4 74594- Hide quoted text -
>
> - Show quoted text -

But actually i want to do further processing with that sorted table.
Thats why i am in need of such structure

Thanks
Arunkumar.D

• Next in forum: Re: sorting table while inserting
• Prev in forum: Re: sorting table while inserting
• Thread view: Re: sorting table while inserting

[Reply to this message]