Setting sort order on a columnHi ,
I have a column EMPID and few other columns in Employee table. I am inserting data to it for ex: Emp Ids 10, 1 ,4,20. But in my table it should get stored in a sequest like 1,4,10,20.
Can I do anything while inserting/updating the data so that order will be maintained properly?
Can we set sort order on a column?
If I make EMPID as primary key , is it going to resolved this sorting problem?