|
|
Posted by Jason Lepack on 05/29/07 16:27
What exactly do you want to do? Maybe there is a better way of doing
it that you haven't come across.
Give a little more detail and more help can be given.
Cheers,
Jason Lepack
On May 29, 12:24 pm, Oonz <arund...@gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Navigation:
[Reply to this message]
|