Select * from #emp Order by id,Groupname

i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K

and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L

Question Posted / archana

8 Answers
7989 Views
I also Faced
E-Mail Answers

Answer Posted / archana

Select * from #emp Order by id,Groupname

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of triggers are there?

1066

What are the commands used in DCL?

1028

Why we use the openxml clause?

1013

What is the purpose of sql profiler in sql server? : sql server database administration

1108

What do you mean by the term 'normalization'?

1210

How to connect of datebase with sql express.?

1104

What is sub-query in sql server?

1205

Explain what is row_number function?

1040

How to scale out a federation by Sql statement?

116

How to Insert multiple rows with a single insert statement?

1056

What types of Joins are possible with Sql Server?

1122

What is the command used to recompile the stored procedure at run time?

1082

Data table as parameter in sql server?

1050

Do you know what is openxml in sql server?

1069

What is the difference between sdf and mdf?

1300