Re: sorting table while inserting

On May 29, 9:27 pm, Jason Lepack <jlep...@xxxxxxxxx> wrote:
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...@xxxxxxxxx> wrote:



On May 29, 9:19 pm, Jason Lepack <jlep...@xxxxxxxxx> 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...@xxxxxxxxx> 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 -- Hide quoted text -

- Show quoted text -


Actually i will combine the multiple numbers into one single record

the temporary table structure would be like this

No Name Phone FinalPhone
1 test1 12345 12345
1 test1 23455 12345<br> 23455
2 test2 68638 68638
2 test2 34454 68638<br> 34454<br>
2 test2 45445 68638<br> 34454<br> 45445
3 test3 67684 67684
4 test4 54808 54808
4 test4 74594 54808<br> 74594


and by using GROUP BY clause i would select single record having all
the
information


No Name FinalPhone
1 test1 12345<br> 23455
2 test2 68638<br> 34454<br> 45445
3 test3 67684
4 test4 54808<br> 74594

this view would be sent to UI for display...

Thanks
Arunkumar.D

.