Sorting Rows in a UserDefined(Custom) way. [Resolved]

My actual requirement is getting my desired row on top and having my specific order. order by gives either Ascending or Descending. But i want a Custom way to have my Defined Order..
For that after googling it i got it....

//Creating a table called #temp

create table #temp( id int primary key,Pref_Score varchar(30)unique)

//and inserting it in the order i require
insert into #temp values(1,'Exceptional')
insert into #temp values(2,'Developing')
insert into #temp values(3,'Strong')
insert into #temp values(4,'Solid')
insert into #temp values(5,'UnAcceptable')

//and then selecting it ..
Select * from #temp order by id

Previously my problem is Even though i insert in the order i require SQL server automatically Sorting it...
So to stop and place my own order i declared a ID column and accessed the values from it....

Thanq Saravanan and RamKumar for your help.

Thanks,
Radha Srikanth

Chvrsri, if this helps please login to Mark As Answer. | Alert Moderator

select Column1, Column2 from tbl_name
order by Column1

P.S. here tbl_name -> your table name and Column1 and Column2 are your columns.

Chvrsri, if this helps please login to Mark As Answer. | Alert Moderator

Hi Ramkumar,
I dont want to sort my data using Columns , i want to use my ROWS to sort as i mentioned clearly......Even wht u said will sort in ascending order, thats not what i wanted.

Thanks,
Radha Srikanth

Chvrsri, if this helps please login to Mark As Answer. | Alert Moderator

hi,
if you sort by column, the row also automatically gets sorted.

pls try.

Chvrsri, if this helps please login to Mark As Answer. | Alert Moderator

Hi Srikanth,

What's your Exact output from your query?

If you need this type of output means,

Column1  Column2

def  2

abc  1

ghi  3

Query --> Select Column1,Column2 from Table1 order by Column2 

else edit your question and what you need for exact output.

Ramkumar answer is correct for your question.

Thanks,
T.Saravanan

Chvrsri, if this helps please login to Mark As Answer. | Alert Moderator